topic Re: How to remove weeks from calendar in DAX Commands and Tips

How to remove weeks from calendar

lucie_rabochova — Mon, 01 Apr 2024 04:53:18 GMT

Hi all,

I have the following DAX code to generate a calendar.

DimDates =

VAR BaseCalendar =

CALENDAR(DATE(2022,1,1), TODAY())

RETURN

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")))

My question is, how can I update this code to remove YearWeekNumber 2022-53 and 2023-53?

Thank you for your answers!

Re: How to remove weeks from calendar

FreemanZ — Mon, 01 Apr 2024 05:12:42 GMT

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 )

Re: How to remove weeks from calendar

lucie_rabochova — Mon, 01 Apr 2024 10:49:53 GMT

Thank you, works perfect!