topic Re: Is Start week True / False in DAX Commands and Tips

Is Start week True / False

Anonymous — Wed, 18 May 2022 21:23:58 GMT

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

Re: Is Start week True / False

amitchandak — Thu, 19 May 2022 01:00:44 GMT

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

Re: Is Start week True / False

BrianConnelly — Thu, 19 May 2022 01:06:04 GMT

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?

Re: Is Start week True / False

Anonymous — Wed, 25 May 2022 06:27:51 GMT

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