Extract Start and End Dates with Power Query - 2 Ways

Method 1 is quick and requires only a few steps, but might run slowly on large datasets. Method 2 requires a few more steps but is likely to run more efficiently if you have a lot of data.

[Rahul-]

Eagerly waiting to upload your video because you always bring one new thing and I learn those method and apply in my professional work

[wayneedmondson]

Hi Mynda.. awesome techniques. Thanks for showing two approaches and for emphasizing the performance consideration.. something to keep in mind when developing solutions.. excellent! Thumbs up!!

[ryanbartlett]

Magic, explained completely, effeciently, and pleasantly ! :-) Thanks!

[HarishS]

Thank you for sharing this technique with us, till date haven't got this requirement!! If I get one, now I know what to be done.

[nathanchow]

This is helpful! Can we do this in reverse? e.g., we have a report with “start date” and “end date” on each column, is that possible to break it down into the format just as your original dataset?

[cherianiype]

@MyndaTracy and team... Happy New Year 2021! You are awesome at this! Thank you for breaking this down so easily! Virtual Hug! Elbow Bump! Take care, stay safe!

[KMHill]

Thank you so much for all of your videos. I am trying to learn a way to determine monthly totals if I have a list a list of customers, their monthly fixed amount and their start and end dates. The query would have to add their monthly amount only to each month's tally, only if the month being tallied falls between the start date listed in one column and the end date listed in another column. If there is no end date, they are still an active customer and would be tallied up and including the current month. Have you done any videos that describe how to set up such a tally?

[zxyzxyzyzyugfd]

Thanks a lot for your videos. My issue is: i have 2 columns. In the first i have number 1 which is January first month, and in the second column i have 2021. I want to create a third column in which I want to have the full date : 31.01.2021. Same for number 2 which is February. How to do it ?

[thestitchmenagerie]

Hi! Thank you for this tutorial! How can I use power query to give me all the dates before the prior year. For example, I need all the lines that have a date before 1/1/2023

[halkawtmohammed]

I have a question but i can't inform you or even explain it to you, but it is really important and crucial for me to learn how to do that as I am doing it manually. I will appreciate if you can help me on that. And I will explain to you through Skype what I need to do exactly. I wish I could explain it here but it is too difficult. But if I show you through the Skype you will get point directly. You save life of million people from doing it manually. Thanks in advance.

[ymoatassimbillah]

Thanks a lot!
I have one question!
how can you get the function visible on the formulas barre while you are tapping, I sought avey where on the internet but unfortunately I haven't found anything.
regards
YMB

[mohmmadabdo]

Thanks a lot 💚
I have a question ..
I start power query and I import the data by chosen "only creat connection" and Add the data to the model,
*Can I transfer the data to table (povit table) any time I need ?*

[nageshkumar]

Hi Mynda, if we have a situation where format is month/date and year is not mentioned. Need to check if this date is 7 days old from current date...can you help in building logic.

[zchase]

how to do the same but add missing dates to existing data that contains other columns with duplicate dates (like an exchange rate table)

[direallocus]

Where do you teach how to write this kind of code (that is, the if statements and
What not )

[ImranHussain-xvse]

Hi, your videos are worth watching. I have a real scenario and want to get your guidance.

I am a SAP user, I receive more than 200 claims/month and same are approved by different person in following way,
Approver 1 receive claim SAP shows status 900, and when he approves it show status as 50 or 68. After first approver, it flows to 2nd approver and shows status as900 and if 2nd approver is on leave then it flows to back up approver showing status as 900 untill claim reaches final approver and when it finally approved it shows status as 70

So for each claim lot of duplicates showing status 50, 68 and 900
My manager asked me to write in column angainst each claim approver name and how much time taken by each for approving

Date of receiving/approving is mentioned in
SAP, please guide how to do
Thanks
Imran

[zchase]

when i expand the list.. i don't get the missing dates as null. The Dates column becomes the same as the list date.

[mattmatt]

What's the full syntax for a try clause ?

[harikrishnareddy]

I need opposite of what u done. I need a single column out of these 2 columns

[eslamfahmy]

Could you provide us with the difference between (excel.workbook) & (excel.current workbook)