Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
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
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!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
69 | |
35 | |
21 | |
18 | |
15 |
User | Count |
---|---|
127 | |
32 | |
27 | |
24 | |
22 |