Forum Discussion
Difference between 2 columns in a Matrix Table
Hi. I am trying to calculate the difference between 2 columns i Desktop. The value is a measure and the columns are one field, pls. see below. I have tried to create a measure but with no luck...
Hi,
If there is also a Date column available in your dataset, then you should create a relatiosnhip between this Date column and the Date column of your Calendar Table. In the Calendar Table, write the following calculated column formulas to extract the Year and Month
Year=year(Calendar[Date])
Month=FORMAT(Calendar[Date],"mmmm")
In your visual, drag Year and Month from the Calendar Table. Then write this measure
[Proposals Count]-CALCULATE([Proposals Count],SAMEPERIODLASTYEAR(Calendar[Date]))
Hope this helps.
Hi Ashish.
It works perfectly! Would it be possible to leave out the difference for 2017 as it is the same value as the count?
Br. Hele
Hi,
I don't think that is possible.