TIPS POWER BI: Membuat Tabel Kalender dengan DAX Formula

on



Dates  = CALENDAR(DATE(2011, 01, 01), DATE(2021, 12, 31))
Year = YEAR(Dates[Date])
MonthNum = MONTH(Dates[Date])
WeekNum = WEEKNUM(Dates[Date])
DayoftheWeek = FORMAT(Dates[Date].[Day], "DDDD")


 

Comments

Post a Comment