Measure to show start and end dates of current ISO week

[Anonymous]

Hello,

I have this measure in a Card visualization which shows the start and end dates of the previous ISO week (starting on Monday and ending on Sunday) but i am having trouble to adapt it to show the dates for the current week. Any help is much appreciated!

Previous ISO Week Dates = FORMAT(today()-SWITCH(WEEKDAY(today(),2),1,1,2,2,3,3,4,4,5,5,6,6,7,7)-6, "d/m/yyyy") & " - " & FORMAT(today()-SWITCH(WEEKDAY(today(),2),1,1,2,2,3,3,4,4,5,5,6,6,7,7), "d/m/yyyy")

Expected results:

25/7/2022 - 31/7/2022

[Anonymous]

@Payeras_BI @Jihwan_Kim Thank you for your reply! The two proposed solutions work. But i can only accept one post as the solution, so i will just go with the first reply. Thanks again to you both!

[Payeras_BI · Accepted solution]

Hi @Anonymous ,

Current ISO Week Dates = 
FORMAT ( TODAY () - WEEKDAY ( TODAY () ,2 ) +1 , "d/m/yyyy" ) & " - " & FORMAT ( TODAY () - WEEKDAY ( TODAY () ,2 ) +7 , "d/m/yyyy" )

[Jihwan_Kim]

Hi,

Please try the below if it works.

Previous ISO Week Dates = 
FORMAT (
    TODAY ()
        - SWITCH ( WEEKDAY ( TODAY (), 1 ), 1, 0, 2, 1, 3, 2, 4, 3, 5, 4, 6, 5, 7, 6 ) - 6,
    "d/m/yyyy"
) & " - "
    & FORMAT (
        TODAY ()
            - SWITCH ( WEEKDAY ( TODAY (), 1 ), 1, 0, 2, 1, 3, 2, 4, 3, 5, 4, 6, 5, 7, 6 ),
        "d/m/yyyy"
    )