Create a date dimension with a date surrogate key Power BI
Published on Sep 02, 2021:
In this video, we learnt to create a date dimension using the DAX calendar function.
The code to create the date dimension is :
CalendarYear = ADDCOLUMNS(CALENDAR(DATE(2000,1,1),DATE(2050,12,31)),"Year" ,YEAR([Date]),"Month",FORMAT([Date],"mmm"),"Month Number",MONTH([Date]),"Month Name",FORMAT([Date],"mmmm"),"Weekday",WEEKDAY([Date],1),"Weekdayname",FORMAT([Date],"dddd"),"DateSgtKy",FORMAT ( [Date], "YYYYMMDD" ))
In the previous video, we discussed why we need a date dimension in Power BI.
1. Improved model performance
2. Minimise data model size
3. DAX code maintanability
Previous Video: • Join Two Fact Tables using a common d...
SUBSCRIBE to learn more about Power BI,Power Query, Power Pivot, Excel,SQL Server and Python!!
/ @learnexcelrelentless
Download M Query code:
http://bit.ly/3kJwUUq
Our Playists:
Extract Load and Transform data using Power Query: http://bit.ly/3orLRf4
Enhance Power BI Data model using DAX: https://bit.ly/2GbTENc
Python and Power BI:https://bit.ly/2EajdNc
Getting Started with AWS: https://bit.ly/2PgSCQX
SQL Playlist :https://goo.gl/PS5Ep6
DAX PlayList : https://goo.gl/S4W41D
Power BI PlayList: https://goo.gl/dXxvnB
Power Query Playlist: https://goo.gl/5QS7P4
Getting Started with Power BI:https://goo.gl/GHakLZ
Getting Started with Python: https://goo.gl/n24P3w
Data Science With Python:https://goo.gl/PeYCR5
Power BI service: http://tiny.cc/sjekmz
Data Modelling with Power BI:https://tinyurl.com/8b4srjrm
ABOUT DAGDOO:
Website:
Home Page: http://www.dagdoo.org/
Power BI Tutorials: http://www.dagdoo.org/excel-learning/...
Questions? Comments and SUGESTIONS? You will find me here:
Twitter: @dagdooe
Category: Science & Technology
License: Standard YouTube License
