Date_Table = ADDCOLUMNS(
CALENDAR(DATE(2023,6,1)
,TODAY()),
"Month-Year",FORMAT([Date],"mmm")&"-"&YEAR([Date]),
"Month",FORMAT([Date],"mmm"),
"MonthNum",FORMAT(MONTH([Date]),"00"),
"Week-Year","Week-" &WEEKNUM([Date],2)&"-"&YEAR([Date]),
"Year",YEAR([Date]),
"YearMonth", YEAR([Date]) & FORMAT(MONTH([Date]), "00"),
"IsWorkingDay",NOT WEEKDAY( [Date] ) IN { 1,7 }
)
No comments:
Post a Comment