Forum Discussion
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())...
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
BrianConnelly
Resolver III
Resolver IIIHanna, more details are needed. What is the fiscal week? For example, I have a fiscal week that starts on Wednesday. Also what does the data look like? Are you using a date table?