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

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

Can any one help?

amitchandak
Super User
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
BrianConnelly
Resolver III
4 years ago
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?
Anonymous
Not applicable
4 years ago
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