Create a date range parameter with Power query | Powerful Tricks to save your time in power query

In Power Query, you can create a date range parameter that allows you to filter your data based on a range of dates. This can be a useful tool if you need to analyze a specific time period or track changes over time.

To create a date range parameter in Power Query, you can use the "From" and "To" date parameters. These parameters allow you to specify the start and end dates of the date range that you want to analyze.

Once you have created your date range parameter, you can use it to filter your data in a variety of ways. For example, you can use it to filter your data by a specific date range, or you can use it to group your data by month or year.

Creating a date range parameter can be a powerful time-saving trick in Power Query, as it allows you to quickly filter and analyze your data without having to manually select dates each time.

[pierregerard]

AWESOME !! BRILLIANT !! I was looking for this for days and was struggling !. Many thx😍🤩

[jmathew]

This is exactly what I was searching for. Very useful tutorial/tip and nicely explained too. You made up well for the lack of Audio Thank you!

[benjaminjoseph]

Even ChatGPT could not provide a clear cut solution as this. Thanks Harry! You are da man!

[bessyvalayil]

Hi Harry, Thank you for the information. Finally, you solved my issues..

[shellylindahl]

Instruction/commentary is really necessary here for what I need

[Ramzanb]

What a wonderful and nice way to describe.

[herreraedgar]

Thasnk bro, I was trying different set of "list." formulas but this one is what I was looking for.

[SucharitaMitra]

Music was awesome, although my issue is to get dates less than equal to 60 days of a creation date.. I will search other videos of yours, but this video music really made me love it

[AzizagaAzizaga]

Everything is clear, vut for EndDate you didn't do anything. You just filtered values for StartDate and you do all process for StartDate, but main data refreshing also works for EndDate?! How does it possible?!

[gamefax]

Microsoft, the most complicated parameter creation you'll find in town. Eh, guess it helps with job protection in the end.

[Narfy]

Hi Harry, thanks for this! It works, however, when there are no dates inputted in the parameter field, it does not return any data. In this scenario, I would like it to return all of the data. Any ideas?

[christinekunz]

Thanks a lot Harry. It seemed like running but the result shows 18 rows loaded and 7 errors. Should I just ignore the errors?

[jasoncowperthwaite]

Can you do this exercise with date and hours in the parameter field?

[MonicaFrieson]

Looks like this might be useful but it's very confusing to follow. It would be much more helpful if there was a narrative. Or at least some subtitles to guide us.

[christinekunz]

Anyone has a vieo how to do the same in powerBI?

[Jahspecs]

You need to narrate also… not everyone is a visual_only learner

[sahabatlontar]

Help me eror code (ParameterName as Text) is The type identifier is invalid.