Forum Discussion

Lexey's avatar
Lexey
Helper I
8 years ago

Percentage between two values

Please help in solving one problem. You need to calculate the percentage as the ratio of [delta plan] and [plan]. Tried different options but have not yet found solutions.

Need Help

6 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi Lexey,

     

    What you want to calculate is 2198/3548=0.6195 for the first row under [delta % plan], right?

     

    If so, you should modify the measure [delta % plan] as below:

    delta % plan = [delta plan]/ [Values of budget]

     

    Best regards,

    Yuliana Gu

    • Lexey's avatar
      Lexey
      Helper I
      8 years ago

      I need row context.,
       1 row = [delta plan]/[Values of budget]
       2  row = [delta plan]/[Values of budget]
      3 row = [delta plan]/[Values of budget]

       

      you get a total percentage that doesn't suit me. Thanks

      • Floriankx's avatar
        Floriankx
        Solution Sage
        8 years ago

        You could try SUMX(Table;[delta plan]/[Values of budget].

         

        This is for a Measure.

        Calculated Column would just be [delta plan]/[Values of budget]

         

        I'm not quite sure wether your columns is name Values of budget or plan.

         

        Please try and let me know.