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. 

Now I would like to make the changes per period vissible. 

 

This is my table; 

 

How can I created an new colomn which calculates the difference between the last and previous period? 

 

Hope to hear from you guys. 

 

  •  

     

    %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]

1 Reply

  • mlsx4's avatar
    mlsx4
    Icon for Memorable Member rankMemorable Member

     

     

    %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]