group by dynamic week

mim ,Please if my blog can help you for week

https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123

Hi mim ,

You couldn't have a calculated column interacted with a slicer or interaction , since columns are only calculated when data is loaded/refreshed.  So you may need to click "Refresh" button for every time you make filter in slicer or interact with other visual.

In addition, you may create the [dynamic Week End] using measure instead of calculated column like DAX below, While it may not be displayed in Data view, you may show it in table visual using fields as you need.

dynamic Week End= MAX([Date]) -MOD(MAX([Date]) - WEEKDAY([Cutt off daily], 2) -2, 7)+6

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Is there an example file we can have a crack at, would love to give it a go!

I undesrtand you wish to group all of the sales for each given week into a seven day period ending on the same day of the week as the selected slicer.

The measure below checks to see if our date on the X-axis is the same day of the week as your slicer. If not it returns BLANK( ), if it is the same day of week, it sums the qty for the previous 7 days.

Qty at 'week end' =
VAR SelectedSlicerDate =
    SELECTEDVALUE ( 'Slicer Dates'[Date] )
VAR ThisDateOnAxis =
    SELECTEDVALUE ( 'Calendar'[Date] )
RETURN
    IF (
        WEEKDAY ( SelectedSlicerDate ) <> WEEKDAY ( ThisDateOnAxis ),
        BLANK (),
        CALCULATE (
            SUM ( 'Data Table'[qty] ),
            DATESBETWEEN ( 'Calendar'[Date], ThisDateOnAxis - 6, ThisDateOnAxis )
        )
    )

I'll attempt to link to a copy of the pbix

Example PBIX file