Creating a Dynamic Calendar Date Range in Power Query

Part one of two of my videos on creating a Power Query Calendar Table. In this video we’ll see two methods for creating either a dynamic or relative date range for a calendar table created in the Power Query Editor.

RELATED CONTENT 🔗

BECOME A CHANNEL MEMBER 🎉

LET'S CONNECT! 🧑🏽‍🤝‍🧑🏽 🌟

VIDEO CHAPTERS 🎥
0:00 - Start of Video
0:32 - Content Intro
1:05 - Min/Max Fact Table Dates
2:27 - Creating List of Dates
5:30 - Min/Max Relative Dates

HAVENS CONSULTING PAGES 📄

EMAIL US AT 📧

#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #calendar #datetable #dates

[starkindustries]

This video was INSANELY helpful. I wanted my between date slicer to always have the full range of data and when I'd refresh the data the max date was stuck on the old max date from when the report was published. This solution worked great and now my date slicer is dynamic. Subbed!

[firoj]

Thanks for the short video on this topic.

[wayneedmondson]

Hi Reid. Awesome tips for creating a dynamic calendar date range in Power Query. Thanks for sharing! Thumbs up!!

[abhishekawari]

How we can create a rolling monthly calendar instead of day, where we hve to pass the monthly argument based on another lookup date feature

[wayneedmondson]

Hi Reid. Just discovered, you can also create the range of dates for the calendar table with: = {Number.From(#"Earliest Sales Date Sales Date (EOY)")} and = {Number.From(#"Relative Date Date End")} vs. using the List.Dates() function. Just another way to accomplish the goal. Do you see any advantage to one method vs. the other? Thanks for the inspiration to learn about this topic. Thumbs up!!

[amar]

Hi is it ok that query folding does not work with the date table in this example. Not sure if query folding works creating a date table in another way.

[ndcqopu]

Hello. Thank you for the video. I have a question to ask you. What part should I adjust to make a date table that has a week interval from the start date to the present date?

[paulinafaryna]

It's good, but still creates a lot of unnecessary data - I don't need all days within these 2 years, I only need the days that exist in the Fact table. Any idea how to do that?

[alphamaniac]

Great help...When i attempt to do the Relative dates, I get the error "Expression.Error: We cannot convert the value #datetime(2020, 1, 1, 0, 0, 0) to type Date. Details: Value=1/1/2020 12:00:00 AM Type=[Type]

[officework]

How do I do this for monthly incremental?

[Negi_From_Pauri]

Please slow your speed its a humble request. I know you will say slow your speed from youtube but the rythem is not good while watching video. it would be good if you slow your speed.