Forum Discussion

Helper II

3 years ago

Need help with how to solve circular reference situation

I need to calculate a value based on its own previous value. I would prefer to do it in DAX. Any help is appreciated

Super User

3 years ago

I think it is a measure like

=2000 + (2000-1000)/20 * calculate(distinctcount(Table[date]) , filter(allselected(Table), Table[Date] < = Max(Table[Date]) ) )

=[measure1]+ ([measure1]-[measure2])/20 * calculate(distinctcount(Table[date]) , filter(allselected(Table), Table[Date] < = Max(Table[Date]) ) )