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

[aravind2409]

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 this

[mussaenda]

Hi @aravind2409 ,

Since you already have the previous month on your data, 

do a measure of resolved count / resolved count - previous month then change the data type to percentage

[aravind2409]

Kindly help please

[aravind2409]

Hello ,

Thanks for checking. I tried and its not working.

My requirement is in Jan percentage is 83.83 and Feb is 85.07 i want the difference between two (85.07-83.33). Kindly help. Thanks in advance for your help

[mussaenda]

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]

Thank you sir.

[aravind2409]

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

[aravind2409]

@mussaenda Kindly help sir.

[mussaenda]

Hi @aravind2409 ,

i responded to you.

Please check the replies

"My requirement is in Jan percentage is 83.83 and Feb is 85.07 i want the difference between two (85.07-83.33)"

according to your  requirement, test1 is correct, right? you just need to change the data type  to %

[aravind2409]

@mussaenda  its not working. i have shared my formulas kindly check and help. am sorry if am bugging you

[mussaenda]

Hi @aravind2409 ,

"My requirement is in Jan percentage is 83.83 and Feb is 85.07 i want the difference between two (85.07-83.33)"

according to your  requirement, test1 is correct, right? you just need to change the data type  to %

[Aravind24]

@mussaenda  Sir, can you please help with my query? Thanks in advance for your help. i have shared my dataset details.