Forum Discussion

sannepenning's avatar
sannepenning
New Member
3 years ago
Solved

Measure difference in an table

Good day all,    I recently started building dashboards in Power-Bi and I'm now trying to start working with DAX formula's.    In my dashboard I've created a table, with percentages per month.  ...
  • mlsx4's avatar
    mlsx4
    3 years ago

     

     

    %last month= CALCULATE([Monthly], PARALLELPERIOD('Calendar'[Date],-1,MONTH))

     

    *I assume that the % values are computed in a measure called Monthly and you are using a Calendar Date

     

    And then your difference:

    diff= [Monthly]-[%last month]
mlsx4's avatar
mlsx4
Icon for Memorable Member rankMemorable Member
3 years ago

 

 

%last month= CALCULATE([Monthly], PARALLELPERIOD('Calendar'[Date],-1,MONTH))

 

*I assume that the % values are computed in a measure called Monthly and you are using a Calendar Date

 

And then your difference:

diff= [Monthly]-[%last month]