Forum Discussion
column calculated using values from previous rows from the same column
I need to create an indicator on power bi equal to one used in excel. Everything okay until I try to refer to the previous value of the indicator. Here's a screenshot of how the indicator structure w...
So maybe something like:
Measure = SUMX('Table', [Rate]* LOOKUPVALUE([Rate2], [Indicator], [Indicator]-1) )
In this case I have problems with circular references.