Power BI Tips Easily add a date dimension table
Here is a very useful and repeatable timesaver for Power BI
This short video shows you how to quickly create a date dimension table in Power BI Desktop
https://www.selectdistinct.co.uk/2022...
To try this yourself, just copy this DAX code
Calendar table =
ADDCOLUMNS(
CALENDAR(DATE( 2020, 1, 1 ), DATE( 2021, 12, 31 ) ),
"DateAsInteger", FORMAT ( [Date], "YYYYMMDD" ),
"Year", YEAR( [Date] ),
"Monthnumber", FORMAT ( [Date], "MM" ),
"YearMonthnumber", FORMAT ( [Date], "YYYY/MM" ),
"YearMonthShort", FORMAT ( [Date], "YYYY/mmm" ),
"MonthNameShort", FORMAT ( [Date], "mmm" ),
"MonthNameLong", FORMAT ( [Date], "mmmm" ),
"DayOfWeekNumber", WEEKDAY ( [Date] ),
"DayOfWeek", FORMAT ( [Date], "dddd" ),
"DayOfWeekShort", FORMAT ( [Date], "ddd" ),
"Quarter", "Q" & FORMAT ( [Date], "Q" ),
"YearQuarter", FORMAT ( [Date], "YYYY" ) & "/Q"
& FORMAT ( [Date], "Q" )
)
Visit our page for more
https://selectdistinct.co.uk/power-bi...
#PowerBI #PowerBITips #SelectDistinct
Music from Uppbeat (free for Creators!):
https://uppbeat.io/t/soundroll/tropicana
License code: ZBD8ASURPZXCLNME