Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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" )
@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!
Hi @Anonymous ,
Current ISO Week Dates =
FORMAT ( TODAY () - WEEKDAY ( TODAY () ,2 ) +1 , "d/m/yyyy" ) & " - " & FORMAT ( TODAY () - WEEKDAY ( TODAY () ,2 ) +7 , "d/m/yyyy" )
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"
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |