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...
In fact, this indicator is generated daily, based on the yesterday indicator number. This indicator column should calculate different results to each day. I need a dax formula that behave just like the excel formula.
So maybe something like:
Measure = SUMX('Table', [Rate]* LOOKUPVALUE([Rate2], [Indicator], [Indicator]-1) )
In this case I have problems with circular references.