Forum Discussion
Solved
calculate difference on two column values on visual Table
I have a Table visual on my dashboard: And i would like to calculate the difference between amount(value from table X) and amount2(value from table Y), and add an extra column to the table vi...
Hi nicknl ,
To create a measure as below. If it doesn't meet your requirement, kindly share your sample data and excepted result to me. Please upload your files to One Drive and share the link here.
difference = SUM(Table1[amount])-SUM(Table1[amount2])
Please find the pbix as attached.
Regards,
Frank
OK, well then something is different between your data model and how it has been described, or at least the vision of it that I have in my head. So, Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
That being said, take a look at Page 6, Tables 9 and 10 of attached.