count the week that can start any day of the week (based on Min slicer value)

Anonymous — Mon, 22 Mar 2021 05:46:02 GMT

How can i make the MIN slicer value (date) as starting day of the week.

any selected value no matter what day it is, will be the start day of the week.

Thank you!

Re: count the week that can start any day of the week (based on Min slicer value)

amitchandak — Mon, 22 Mar 2021 06:16:01 GMT

Anonymous , Expected output is not very clear.

You can get start and end of week like

Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],1)+1
Week End date = 'Date'[Date]+ 7-1*WEEKDAY('Date'[Date],1)

In case you need WOW, refer