Calendar data update

[Anonymous]

Hi Team,

What do I need to do to

a)  Add week to this dax code (Monday - Sunday)

b) Add a piece of code to take account of today's date date_to

Calendar =

VAR __MIN =

    DATE ( 2022, 1, 1 )

VAR __MAX =

    DATE ( 2024, 12, 31 )

VAR __BASE =

    CALENDAR ( __MIN, __MAX )

VAR __RESULT =

    ADDCOLUMNS (

        ADDCOLUMNS (

            __BASE,

            "Year", YEAR ( [Date] ),

            "Month Long", FORMAT ( [Date], "mmmm" ),

            "Month Short", FORMAT ( [Date], "mmm" ),

            "Month Number", MONTH ( [Date] ),

            "Month and Year", FORMAT ( [Date], "mmm-yy" ),

            "YYYYMM", FORMAT ( [Date], "YYYYMM" ),

            "Quarter", "Q" & QUARTER ( [Date] ),

            "Day of Week Long", FORMAT ( [Date], "dddd" ),

            "Day of Week Short", FORMAT ( [Date], "ddd" ),

            "Day Sort", WEEKDAY ( [Date], 1 ),

            "Week of Year", WEEKNUM ( [Date] ),

            "Week Ending Saturday",

                VAR __DAY =

                    WEEKDAY ( [Date] ) - 7

                RETURN

                    [Date] - __DAY,

            "Week Ending Wednesday",

                VAR __DAY =

                    WEEKDAY ( [Date] ) - 4

                RETURN

                    [Date] - __DAY

        ),

        "Week Starting Thursday", [Week Ending Wednesday] - 6

    )

RETURN

    __RESULT

[speedramps · Accepted solution]

Simply add this new calculated column to your data table to get the week number

Week = 
// week starts Monday and ends Sunday
YEAR('Calendar'[Date]) 
& "-" &
FORMAT(WEEKNUM('Calendar'[Date],2),"00")

Please click "accept solution" and the thumbs up buttons