Скачать или смотреть LESSON 10070 | CREATING A CALENDAR TABLE IN A POWER BI PROJECT | Free Power BI Course

In this video, I guide you through creating a dynamic D Calendar Table in Power BI using the DAX Calendar function, without importing data. You'll learn how to dynamically define the start and end dates based on the F_Sales table, even if the actual date range is unknown. I also troubleshoot a common data modeling issue—missing date columns—and show how to correct it in Power Query. Then, I walk you through marking the calendar as a date table, creating relationships, and using it with slicers to enable flexible time-based analysis. This is essential for building robust data models in Power BI.

📈 Get the data packs for our courses: https://immalytics.com/packs?utm_sour...

🟡 Power BI Playlist: 👉🏻    • POWER BI FROM A TO Z  
🟣 DAX Foundations Playlist: 👉🏻    • DAX FOUNDATIONS  
🟢 Power Query Fundamentals Playlist: 👉🏻    • POWER QUERY COMPLETE FREE COURSE  

💻 For all playlists, visit our website: https://immalytics.com

Chapters
00:00 Creating a Calendar Table in Power BI using DAX
01:10 Opening Table View and starting a new calculated table
02:05 Using the CALENDAR() function with dynamic start and end dates
03:20 Realizing the "Date" column is missing from the F_Sales table
04:10 Fixing the issue by modifying the SQL query in Power Query
05:25 Adding the DateKey column and changing its type to Date
06:15 Creating the D Calendar table with MIN and MAX dates from F_Sales
07:10 Establishing a relationship between the Calendar table and F_Sales
08:00 Marking the new table as the official Date table
08:50 Adding the calendar to a slicer for dynamic date filtering

#powerqueryeditor #powerbi #freecourseimmalytics #powerqueryeditor #powerquerycourse #sql #sqlserver