Forum Discussion
Matrix Showing Difference Between Two Years
I have a matrix, shown below, that I want to show the difference between the two selected years. I am unsure of the formula to calculate the difference, but when I add it to the values of the matrix, the result shows the difference btween the tweo sets of data. Here is an example of what I am looking for:
Hi Anon2020 , Thank you for reaching out to the Microsoft Fabric Community Forum.
I reproduced the scenario on my end using sample data and it worked successfully. To help you better understand the implementation, I’ve attached the .pbix file for your reference. Please take a look at it and let me know your observations.
Thank you for being part of the Microsoft Fabric Community!
19 Replies
this is as close as I can get, but still not showing difference, and still showing values between fiscal years instead of in the last column
Anon2020 You would need to get the Maximum and Minimum values for the Opp_FY_c column. Then you would need to have 2 CALCULATE statements where you calculate the SUM for the TotalPrice column, once for the Maximum value and once for the Minimum value. Modify your filter clause within each CALCULATE statemetn. Then you simply need to subtract one from the other.
would be be so kind to show me?
Hi,
Share the download link of the PBI file.
That is not a downoadable file link. That link takes me to a sign-in page.
Let me know if you have troublke accessing the link
Hello Anon2020 ,
The link does not work. Please store the pbix file in a Google drive (with public permissions) or a Dropbox (again public) or a public repo in Github whichever you prefer. Please make sure that you remove any sensitive data beforehand.
Or, you could simply add sample data in a table format (that can be copied so not an image) and drop the measure definitions (if any) or any particular steps to recreate your visual.
Hi Anon2020 , hope you are doing great. May we know if your issue is solved or if you are still experiencing difficulties. Please share the details as it will help the community, especially others with similar issues.
Also, your sample data links doesn't work, so if your issue is not solved. can you please re-send them.Hi Anon2020 , Thank you for reaching out to the Microsoft Fabric Community Forum.
I reproduced the scenario on my end using sample data and it worked successfully. To help you better understand the implementation, I’ve attached the .pbix file for your reference. Please take a look at it and let me know your observations.
Thank you for being part of the Microsoft Fabric Community!
Hi Anon2020 , Hope you're doing okay! May we know if it worked for you, or are you still experiencing difficulties? Let us know — your feedback can really help others in the same situation.
Hi Anon2020 , Hope you're doing fine. Can you confirm if the problem is solved or still persists? Sharing your details will help others in the community.
