Forum Discussion
Comparing data to a base year, calculate difference and % change
lbendlin , thanks for your concern about this case. I tried to create a sample data myself based on the user's requirement and implemented the result. Please check if there is anything that can be improved. Here is my solution:
Hi dp_75 ,I created some data:
Here are the steps you can follow：
1. Create measure.
Calc 2019 Avg = AVERAGEX( FILTER(ALL('Table'),'Table'[Year]=2019&&'Table'[Month]=MAX('Table'[Month])),[Value])Avg Value vs 2019 avg = DIVIDE( AVERAGEX('Table',[Value]),[Calc 2019 Avg])-12. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Super UserPlease provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Thanks Ibendlin - i think we've got the answer here. I will add a sample file next time as you suggest - much easier to deal with.
regards
DP_75