Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I have the following DAX code to generate a calendar.
Solved! Go to Solution.
hi @lucie_rabochova ,
try like:
DimDates =
VAR BaseCalendar =
CALENDAR(DATE(2022,1,1), TODAY())
RETURN
FILTER(
GENERATE(
BaseCalendar,
VAR BaseDate = [Date]
VAR YearDate = YEAR(BaseDate)
VAR Week = WEEKNUM(BaseDate,2)-1
RETURN
ROW (
"Year",YearDate,
"YearMonth",FORMAT(BaseDate,"yyyy-mm"),
"Quarter", FORMAT(BaseDate, "\Quarter q"),
"Weeknumber",WEEKNUM (BaseDate,2),
"YearWeeknumber", FORMAT(BaseDate,"yyyy") &"-"& FORMAT(WEEKNUM (BaseDate,2),"00")
)
),
[Weeknumber]<>53
)
Thank you, works perfect!
hi @lucie_rabochova ,
try like:
DimDates =
VAR BaseCalendar =
CALENDAR(DATE(2022,1,1), TODAY())
RETURN
FILTER(
GENERATE(
BaseCalendar,
VAR BaseDate = [Date]
VAR YearDate = YEAR(BaseDate)
VAR Week = WEEKNUM(BaseDate,2)-1
RETURN
ROW (
"Year",YearDate,
"YearMonth",FORMAT(BaseDate,"yyyy-mm"),
"Quarter", FORMAT(BaseDate, "\Quarter q"),
"Weeknumber",WEEKNUM (BaseDate,2),
"YearWeeknumber", FORMAT(BaseDate,"yyyy") &"-"& FORMAT(WEEKNUM (BaseDate,2),"00")
)
),
[Weeknumber]<>53
)