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 this

 

Need Help

11 Replies

  • mussaenda's avatar
    mussaenda
    Community Champion
    2 years ago

    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's avatar
      aravind2409
      New Member
      2 years ago

      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'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)'))