How to remove weeks from calendar

[lucie_rabochova]

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!

LR

[lucie_rabochova]

Thank you, works perfect!

[FreemanZ · Accepted 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
    )