Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Weekday DAX : Mon-Mon, Tue-Tue comparo

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. 

 

 

   

Need Help
Tips and Tricks
  • v-xiaotang's avatar
    v-xiaotang
    3 years ago

    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.

1 Reply

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity Support
    3 years ago

    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.