Hello,
I search to calculate a recursive expression in straight table. It is a measure that depends on the value that comes directly before it:
Solde(0)= [valeur Stock Initial] +[Valeur Arrivée regroupement] - [ traitée Jour ] If Flag_First_Day=1
Solde(i)=Solde (i-1) +[Valeur Arrivée regroupement] - [traitée Jour] else
I calculated the measures used in my recursive expression in script, so i have [valeur Stock Initial] and [Valeur Arrivée regroupement] and [ traitée Jour ], each field is in different table
I attached the data model
Itried to use the function above() but I couldn't have the right result!
Help me plz to find solution to my problem
Thank you