Create Dimension Date Table in POWER BI

Опубликовано: 13 Октябрь 2024
на канале: Rahim Zulfiqar Ali
745
27

DAX TEMPLATE:

dimDate =
ADDCOLUMNS(
CALENDARAUTO(),
"Year", YEAR([Date]),
"QuarterNr", QUARTER([Date]),
"Quarter", FORMAT([Date],"\QQ"),
"MonthNo", MONTH([Date]),
"Month",FORMAT([Date],"MMM"),
"WeekDayNr",WEEKDAY([Date]),
"Weekday",FORMAT([Date],"DDD"),
"YearMonth",EOMONTH([Date],0)
)