Creating a Dynamic Calendar Date Range in Power Query

Опубликовано: 03 Октябрь 2024
на канале: Havens Consulting

24,960

223

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 🔗
Part Two: Creating Hierarchy Columns --    • Creating Date (Calendar) Hierarchy Co...

BECOME A CHANNEL MEMBER 🎉
--    / @havensconsulting

LET'S CONNECT! 🧑🏽‍🤝‍🧑🏽 🌟
--   / havensbi
--   / reidhavens
--    / havensconsulting

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 📄
Home Page - http://www.havensconsulting.net
Blog -- http://www.havensconsulting.net/blog-...
Blog Files -- http://www.havensconsulting.net/blog-...
Files & Templates -- http://www.havensconsulting.net/files...
Consulting Services -- http://www.havensconsulting.net/consu...
Online Courses -- https://www.havensconsulting.net/onli...
Contact & Support - http://www.havensconsulting.net/conta...

EMAIL US AT 📧
[email protected]

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