Forum Discussion
rp2022
Helper II
Helper IINeed 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
amitchandak
Super User
Super Userrp2022 ,
I think it is a measure like
=2000 + (2000-1000)/20 * calculate(distinctcount(Table[date]) , filter(allselected(Table), Table[Date] < = Max(Table[Date]) ) )
or
=[measure1]+ ([measure1]-[measure2])/20 * calculate(distinctcount(Table[date]) , filter(allselected(Table), Table[Date] < = Max(Table[Date]) ) )