Forum Discussion
Solved
Need help in getting the difference
Hi Everyone,
I need help in getting the difference between two columns. I want to get the difference of those number in 2017 and in 2018. The 2017 and 2018 is inside the same column.
Thanks!
This is unfortunately the problem with Using Columm Field.
You will get a MEASURE for each distinct value of the Column
There are 2 ways to deal with it
1) you can hide the extra MEASURE Column...hide the totals.....But you will have to adjust the Word wrap properties
I do not recommend this.
2) Another approach is to Remove the YEAR from columns and instead use 3 MEASURES as follows.
Put these MEASURES in the VALUES section2018=CALCULATE ( Expression, Table1[Year] = 2018 ) 2017=CALCULATE ( Expression, Table1[Year] = 2017) Difference = [2018] - [2017]
6 Replies
Try this pattern
Measure = CALCULATE ( Expression, Table1[Year] = 2018 ) - CALCULATE ( Expression, Table1[Year] = 2017 )What do I put for the Expression? COUNT(...)?
