Forum Discussion

rp2022's avatar
rp2022
Icon for Helper II rankHelper 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

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    rp2022 ,

    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]) ) )