Comparison DAX

[Anonymous]

Hi,

I am trying to compare same weekday sales from prior year and also % difference. (It's a day level comparison)

Let me explain what I mean by that:

I want to compare sales between

"1st Jan 2019(Monday)" vs "2nd Jan 2018 (Tuesday) "  because they are the first tuesday of that month

                   and similarly

"2nd Jan 2019 (Wednesday)" vs "3rd Jan 2018 (Wednesday) " and so on. And I have to assign comparable weekday of each month as "P" and non comparable days as "T" and also If there is no sales for more than 6 days it should eliminate it and compare other days and assign "P" and  "T" accordingly.

Please help me to acheive this!!! 

TIA

[v-yuta-msft]

@Anonymous ,

---

I want to compare sales between

"1st Jan 2019(Monday)" vs "2nd Jan 2018 (Tuesday) "  because they are the first tuesday of that month

                   and similarly

"2nd Jan 2019 (Wednesday)" vs "3rd Jan 2018 (Wednesday) " and so on. And I have to assign comparable weekday of each month as "P" and non comparable days as "T" and also If there is no sales for more than 6 days it should eliminate it and compare other days and assign "P" and  "T" accordingly.

---

Could you share more details about your requirement and expected result? If possible, please also share some sample data for further analysis.

Regards,

Jimmy Tao

[Anonymous]

Thnak you for your response. Please check the image below and help me.I want to achieve like this for each month of a yearIf the shop is closed for particular period then it assign P nd T with respect to the comparable days