Forum Discussion

Regular Visitor

6 years ago

Solved

Loops

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
6 years ago
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.

Community Champion

6 years ago

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.