Forum Discussion
Difference between 2 Cell values in a Matrix
Hi vijeth_sankethi,
I entered some data to do a test. Based on my test, you can refer to below steps in query editor:
This picture show the data I entered.1.Pivot your [column3],choose the Values Column [Column2].
2.Add the three Custom Columns to show your data.
Deviation Submission=[Actual Submissions]-[Estimated Submissions]
Deviation Application=[Actual Applications]-[Estimated Applications]
Deviation Fundings=[Actual Fundings]-[Estimated Fundings]
3. Unpivot all of your columns except the [Column1].4.Create a Matrix visual to show your data.
For more information, see attached pbix file.
Best Regards,
Qiuyun Yu
Hi vijeth_sankethi,
I entered some data to do a test. Based on my test, you can refer to below steps in query editor:
This picture show the data I entered.
1.Pivot your [column3],choose the Values Column [Column2].
2.Add the three Custom Columns to show your data.
Deviation Submission=[Actual Submissions]-[Estimated Submissions]
Deviation Application=[Actual Applications]-[Estimated Applications]
Deviation Fundings=[Actual Fundings]-[Estimated Fundings]
3. Unpivot all of your columns except the [Column1].
4.Create a Matrix visual to show your data.
For more information, see attached pbix file.
Best Regards,
Qiuyun Yu
Hi v-qiuyu-msft,
I was trying something on the similar lines. Thanks for putting a lot of effort to get this resolved. I will accept this solution.
Thanks,
Vijeth
