Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn 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
)
User | Count |
---|---|
53 | |
35 | |
20 | |
16 | |
15 |
User | Count |
---|---|
94 | |
72 | |
30 | |
22 | |
16 |