Forum Discussion

lucie_rabochova's avatar
lucie_rabochova
Icon for Helper I rankHelper I
2 years ago
Solved

How to remove weeks from calendar

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
 
"DAX help"
"DAX"
CALENDAR()
  • FreemanZ's avatar
    FreemanZ
    2 years ago

    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
    )

2 Replies

  • FreemanZ's avatar
    FreemanZ
    Icon for Super User rankSuper User
    2 years ago

    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
    )