Forum Discussion

Anonymous

Not applicable

7 years ago

Solved

Power BI Compounding/Iteration Issue

Hi All, First time post. I've hit a wall and am looking for some creative ways to overcome it. I have a formula that needs to reference a prior value, iterating upon itself. I have a calc...

Need Help

Anonymous
7 years ago
Thanks for the response. I'll take a look at these!

I'm also beginning to suspect that the issue with my roundabout way of iterating may be due in part to issues with relationships.

Regards,
Quinn

Greg_Deckler

Community Champion

7 years ago

I did not read all of this post because iterating is something DAX hates. Best to do that kind of thing in M code. But, here are some cases where I have sort of solved it.

https://community.powerbi.com/t5/Community-Blog/Kaplan-Meier-Survival-Curves-with-Power-BI-Part-1/ba-p/332819

https://community.powerbi.com/t5/Quick-Measures-Gallery/Runge-Kutta/m-p/411280

https://community.powerbi.com/t5/Community-Blog/Runge-Kutta-and-the-Limits-of-DAX/ba-p/357501

Also, read my articles on "Fun with Graphing with Power BI". I get into some recursion with the fractals.

https://www.linkedin.com/pulse/fun-graphing-power-bi-part-1-greg-deckler-microsoft-mvp-

https://www.linkedin.com/pulse/fun-graphing-power-bi-part-sqrtpowersqrt82-deckler-microsoft-mvp-

https://community.powerbi.com/t5/Community-Blog/Fun-with-Graphing-in-Power-BI-Part-3i/ba-p/365784

https://community.powerbi.com/t5/Community-Blog/Fun-with-Graphing-in-Power-BI-Part-5-by-5/ba-p/407724

Anonymous

Not applicable

7 years ago

Thanks for the response. I'll take a look at these!