Change first day of week for weekly bins

[CloudMonkey]

Hi,

I have some data grouped into weekly bins (every 7 days) which is working great but I noticed the first day of each 7 day bin is a Sunday. Please can you tell me how to change this to a Monday?

Thanks,

CM

[v-cherch-msft · Accepted solution]

Hi @CloudMonkey 

You may create a calculated column like this post.

Column = 
VAR d =
    MAX(  Table2[date] )
RETURN
    d
        - QUOTIENT ( DATEDIFF ( Table2[Date], d, DAY ), 7 ) * 7

Regards,