Comparision of sales

[sanc_152]

Hi All,

I have the data with following snippet .I want to compare the current year forecast actuals with privious year actuals on forecastweeknumber scale on x axis .How can I create measure in dax.The result should be displayed based on forecastweek.

Forecastweek	Year	actuals
2022-01	2022	200
2022-02	2022	201
2022-03	2022	202
2022-04	2022	203
2022-05	2022	204
2022-06	2022	205
2022-07	2022	206
2023-01	2023	207
2023-02	2023	303
2023-03	2023	304
2023-04	2023	305
2023-05	2023	306

Result in picture view

@Ahmedx 

@amitchandak 

Can you please help.

[Ahmedx · Accepted solution]

I created an example, I really hope it will help you

https://1drv.ms/u/s!AiUZ0Ws7G26RiyEnIEg5m8VgopCr?e=kPDzlD

[Uzi2019 · Accepted solution]

Hi @sanc_152 
I hope the below solution works for you.
Create measure like below:

I hope my post helps you. Please give kudos and accept it as a solution!
Thanks!

[Ahmedx · Accepted solution]

I created an example, I really hope it will help you

https://1drv.ms/u/s!AiUZ0Ws7G26RiyEnIEg5m8VgopCr?e=kPDzlD