Is Start week True / False

[Anonymous]

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()) 

I know it is incomplete, it needs = to work.

Can any one help?

@tamerj1

[Anonymous]

Hi @Anonymous,

Did you mean the start date of the month or week? Can you please share some more detailed descriptions and the expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[BrianConnelly]

Hanna, 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?  

[amitchandak · Accepted solution]

@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