Calender DAX Help Needed

[repsol]

Need a calender which has Week Start Date as Thursday and Week End Date as Wednesday. 

Anyone - Pls need some help with above. 

[amitchandak]

@repsol , What weekday start you need. All calendar is discussed in this post

https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Powe...

Please find pbix after the signature.

[harshnathani]

Hi @repsol ,

Create Calculated Columns in your Date Table.

SoWDate = 'Date'[Date] - WEEKDAY('Date'[Date],2)+ 4

EOWDate = 'Date'[Date] - WEEKDAY('Date'[Date],2)+ 4 + 6

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)