Re: Year Over Year

Anonymous · ‎06-22-2022

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 · ‎06-28-2022

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Anonymous · ‎06-29-2022

Update here

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

Whitewater100 · ‎06-22-2022

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!