Forum Discussion
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...
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)'))
Thank you sir.