Forum Discussion

mrothschild's avatar
mrothschild
Continued Contributor
5 years ago
Solved

Calculating % change from a matrix table

Link to PBIX file is: https://drive.google.com/file/d/1j_4CrUj0fPh0xK6hnO7OZ-uIWkoP5Kdg/view?usp=sharing   I'm trying to take the following Matrix output and calculate the natural log, or LN([value...
  • Anonymous's avatar
    Anonymous
    5 years ago

    HI mrothschild,

    It sounds like you are trying to recursion calculation to invoke the previous result of the current expression, right? If that is the case, you can use iterator functions to achieve cumulative calculation but power bi does not support recursion calculations.

    Previous Value (“Recursion”) in DAX - Microsoft Power BI Community

    Regards,

    Xiaoxin Sheng