Loops

[PowerBI129]

Good afternoon everyone,

I was wondering if there was any way to use a loop in power bi desktop ?

Thank you in advance!

[v-yuta-msft · Accepted solution]

@PowerBI129 ,

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.

[Greg_Deckler]

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.