Forum Discussion

Anonymous

Not applicable

4 years ago

Solved

Is Start week True / False

Hi everyone, I need a column shows True if the date is Start Week and False if not. I wrote this Week Start Date = if('Date'[FullDate] - WEEKDAY('Date'[FullDate],2) + 1 , True(), False())...

DAX

amitchandak
4 years ago
Anonymous , this seems fine for Monday

Week Start Date = if('Date'[FullDate] -1* WEEKDAY('Date'[FullDate],2) + 1 , True(), False())

For Sunday

Week Start Date = if('Date'[FullDate] -1* WEEKDAY('Date'[FullDate],1) + 1 , True(), False())

For ant other refer

Any Weekday Week - Start From Any day of Week
https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Power-BI-Turning/ba-p/1187482