Forum Discussion

aravind2409's avatar
aravind2409
New Member
2 years ago

Need help with manually calculating difference between two percentage or numbers and cond. formattin

Hi All,   I have a data like this. Need help with subtracting Jan - Feb and Feb - March like wise and show the difference. Kindly help this is bit urgent. Would be great if some one can help on thi...
Need Help
mussaenda's avatar
mussaenda
Community Champion
2 years ago

Hi, 

 

It was not indicated on your first post that you need the percentage value difference.

 

Anyway, i had no idea how the Total Resolved % is claculated. 

but if this is what you want to achieve,


use  the previousmonth function for the % and the subtract them

Resolved % LM = 


CALCULATE(
    [RESOLVED %],
    PREVIOUSMONTH('Table (2)'[Date]),
    REMOVEFILTERS('Table (2)'))

 

 

 

 

aravind2409's avatar
aravind2409
New Member
2 years ago

Thanks for taking time and considering my query. Let me share my formulas fully.

Here is the details:

Previous Month:

Resolved Count:

 

 

Please advice on my output. I tried with your earlier suggestions its not coming 

 

I am requesting your help kindly. Thanks and this is bit critical to complete the automation. I am sorry if am bugging / troubling you