Forum Discussion

HEW's avatar
HEW
Helper III
7 years ago

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...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

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.

 

  • HEW's avatar
    HEW
    Helper III
    7 years ago

    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

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      7 years ago

      Hi,

       

      I don't think that is possible.