Forum Discussion

nicknl's avatar
nicknl
Regular Visitor
7 years ago
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...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    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

v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

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

v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi nicknl ,

 

Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

 

Regards,
Frank