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

       

       

       

       

      • 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

  • aravind2409's avatar
    aravind2409
    New Member
    2 years ago

    Kindly help please