cancel
Showing results for
Did you mean: Helper I

## 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 467 01-Sep-20 494

It should show something like this:

 Month OnGoing increase/decrease 2020-06 499 2020-07 397 -20% 2020-08 467 18% 2020-09 494 6%

Thanks for the help

1 ACCEPTED SOLUTION Community Support

Hi @Emanuel ,

``````Measure =
var currmonth = CALCULATE(SUM('Table'[OnGoing]))
return
DIVIDE(currmonth-lastmonth,lastmonth)`````` Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2 Community Support

Hi @Emanuel ,

``````Measure =
var currmonth = CALCULATE(SUM('Table'[OnGoing]))
return
DIVIDE(currmonth-lastmonth,lastmonth)`````` Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Super User IV

@Emanuel , You can use time intelligence with date table

example

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))
last month Sales = CALCULATE(SUM(Sales[Sales Amount]),previousmonth('Date'[Date]))
this month =MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(ENDOFMONTH('Date'[Date])))
last MTD (complete) Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(ENDOFMONTH(dateadd('Date'[Date],-1,MONTH))))
previous month value = CALCULATE(sum(''Table''[total hours value]),previousmonth('Date'[Date]))

diff = [MTD Sales]-[last MTD Sales]
diff % = divide([MTD Sales]-[last MTD Sales],[last MTD Sales])

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

Tutorial Series Dax Vs SQL Direct Query PBI Tips   