Forum Discussion

Gladiator909's avatar
Gladiator909
Helper I
3 years ago
Solved

Understanding Percentages - Calculating future value

Hi guys,   I am stuck on what should be a pretty straight forward dax measure. I am hoping I can get some clarity on how the percentages work in Power BI. Here is my table:   Marble Color Pre...
  • LuizKoller's avatar
    3 years ago

    Hey,

     

    Try using SUMX:

     

    Total Projection =
    SUMX('Table', [Recovery Rate] * 'Table'[Previous Amount])



    This evaluate line by line and sum each time.