Year Over Year

[Anonymous]

Why is the YoY change incorrect for the current year but not the past years?

2021 value is ~$440M and 2022's value is ~$197M so why is it saying a positive 14% change?

If were talking YTD values for the past two years 2021 value would be ~$161M and 2022 would be the same ~$197M which is roughly a 22% increase. 

I do not understand why the most recent YoY calculation is incorrect - any tips?

[v-shex-msft]

Hi @Anonymous ,

Can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[Anonymous]

Update here

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Year-Over-Year-measure-incorrect-for-current-...

[Whitewater100]

Hi:

A good answer can come if you can supply your measures and the tables/relationships in your model, or some thing close to that. Could it be your measure is on opening balance YoY?

Thanks!

[Anonymous]

Updated here.

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Year-Over-Year-measure-incorrect-for-current-...