Forum Discussion
Update Data in Power BI Based on Previous rows, using Measures
Hi, I have data like this: Months Supply BOH Demand EOH 1 50 100.00 50.00 100.00 2 60 3 70 4 80 5 90 6 100 7 110 ...
Hi Anonymous ,
As your calculate logic, you will use the previous result in current row. This seems like iteration. I think Dax doesn't support us to calculate in iteration logic. I suggest you to achieve your goal by Power Query.
For reference:
List.Generate() and Looping in PowerQuery
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.