Weekday DAX : Mon-Mon, Tue-Tue comparo

[Anonymous]

Hi people, Need your help to solve my query. Straight to my question- 

I want to compare (monday -monday) or (tuesday - tuesday) sales for the respective week. 

Example: June 1st week Monday - July 1st week Monday(Dates can vary). How do I do this? your help is very much appreciated.

I want this to be dynamic. irrespective of the months i compare. Always the respective week(Day - Mon,tue,wed etc..) data should map with another. 

[v-xiaotang · Accepted solution]

Hi @Anonymous 

Thanks for reaching out to us.

One idea, you can use edate() function to get the date 1 or 2 months ago, then filter date by same weekday number, for example (sample file attached below)

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.