column calculated using values from previous rows from the same column

[fernandoglrt]

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 works in excel. How could i do this "G2" reference in power bi?

[Aron_Moore]

Looks like you're after a rolling or cumulative. Try https://www.daxpatterns.com/cumulative-total/ or maybe a SUMX with EARLIER.

Basically, you need to tell the DAX which row so you'll need to use the date or an index column.

[fernandoglrt]

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.

[Aron_Moore]

So maybe something like:

    Measure = SUMX('Table', [Rate]* LOOKUPVALUE([Rate2], [Indicator], [Indicator]-1) )

[fernandoglrt]

In this case I have problems with circular references.