Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello Team,
I have a Column as shown below with Formula Measure in the table column,
Hi,
You need to have a date table where you should have week no ( 1-52/53) and also Week ending date. This is standard in date table. Once you have that, create a slicer on the week no, which will give you a "between" slicer and you should be able to drag. Now by default, week no will appear in values. But you can first change color to white to make those disappear and then create 2 measures.
Min EoW =
"CW" &
MIN(d_date[Week of the Year]) &
" (Ending " &
FORMAT(MIN(d_date[End of Week]), "dd mmm") &
")"
Max EoW =
"CW" &
MAX(d_date[Week of the Year]) &
" (Ending " &
FORMAT(MAX(d_date[End of Week]), "dd mmm") &
")"
Put those 2 measures in a card visual and allign on top of your slicer.
Hope this resolves your problem.
If this helps to resolve your problem, then please mark it as solution provided, Thanks!
User | Count |
---|---|
98 | |
90 | |
84 | |
70 | |
67 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |