Forum Discussion

Emanuel's avatar
Emanuel
Icon for Helper I rankHelper I
5 years ago
Solved

Increase/Decrease percentage

Hello,   I need some help calculating the increase/decrease in percentage of the values compared to the previous month:   Month        OnGoing 01-Jun-20 499 01-Jul-20 397 01-Aug-20 4...
Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    5 years ago

    Hi Emanuel ,

     

    Measure = 
var lastmonth = CALCULATE(SUM('Table'[OnGoing]),DATEADD('Table'[Month],-1,MONTH))
var currmonth = CALCULATE(SUM('Table'[OnGoing]))
return
DIVIDE(currmonth-lastmonth,lastmonth)

     

     

v-xuding-msft's avatar
v-xuding-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi Emanuel ,

 

Measure = 
var lastmonth = CALCULATE(SUM('Table'[OnGoing]),DATEADD('Table'[Month],-1,MONTH))
var currmonth = CALCULATE(SUM('Table'[OnGoing]))
return
DIVIDE(currmonth-lastmonth,lastmonth)