Percentage calculation Help

[mahitham]

Hi Experts,

Can any one please help me on below requirement.

I have Two KPIs Current Month Amount and Previous Month Amount

[CM Amount] =Count({<[Month Year]={$(=Max([Month Year]))}>}Sales)          Result : 32.68

[PM Amount] =Count({<[Month Year]={$(=Max([Month Year])-1)}>}Sales)      Result : 27.31

Please help me to write the expression for how much Amount Percentage increased in Current Month compared to Previous Month.

Thanks in advance

[tush]

Hi,

     Please refer below link:-

Calculating Percentage Change

[raceberos · Accepted solution]

you can try this

(

Count({<[Month Year]={$(=Max([Month Year]))}>}Sales)  

/

Count({<[Month Year]={$(=Max([Month Year])-1)}>}Sales)

)

-1

the increase would be 20%

so you can get the percentage increase