Forum Discussion
Loops
Good afternoon everyone,
I was wondering if there was any way to use a loop in power bi desktop ?
Thank you in advance!
I'm afraid DAX engine doesn't support loop/recursion, however, in power query, you can use recursion, you may also refer to blogs below:
https://www.thebiccountant.com/2017/09/26/recursion-m-beginners/
https://www.poweredsolutions.co/2019/07/01/recursive-functions-in-power-bi-power-query/
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
So DAX does not support looping in the traditional sense, but you can emulate it to some degree:
https://community.powerbi.com/t5/Community-Blog/For-and-While-Loops-in-DAX/ba-p/636314
https://community.powerbi.com/t5/Community-Blog/Previous-Value-Recursion-in-DAX/ba-p/638320
Power Query supports true recursion but not looping in a traditional sense.
I'm afraid DAX engine doesn't support loop/recursion, however, in power query, you can use recursion, you may also refer to blogs below:
https://www.thebiccountant.com/2017/09/26/recursion-m-beginners/
https://www.poweredsolutions.co/2019/07/01/recursive-functions-in-power-bi-power-query/
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
