Forum Discussion
Convert Excel function to DAX - Power BI (Circular Reference Error)
csinha You cannot do either looping or recursion in DAX. Believe me I have tried. You will need to use Power Query to do the recursion.
Here is a thing on Recursion in DAX - https://www.linkedin.com/pulse/previous-value-recursion-dax-greg-deckler-microsoft-mvp-/
Here is a thing on Recursion in Power Query - https://www.linkedin.com/pulse/fun-graphing-power-bi-part-5-by-5-greg-deckler-microsoft-mvp-/
Hey Greg_Deckler,
Thanks a lot for replying. I read your post on the Fibonacci Numbers just today, and abolsutely loved it!
Although I do suspect that the issue is recursive functions, I am not sure of it. I think I am way too new to Power BI and DAX to even identify it correctly.
I'd be extremly grateful if you could you please go through the excel file, you just might find a solution. I'm really desperate here.
Thanks a ton!csinha Thanks, I've been fighting recusion in DAX for forever. I'll try to take a look but could take some time to try to unwind it all and see if there are any "creative" solutions!
