Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Good afternoon everyone,
I was wondering if there was any way to use a loop in power bi desktop ?
Thank you in advance!
Solved! Go to Solution.
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.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
105 | |
79 | |
69 | |
62 |
User | Count |
---|---|
142 | |
106 | |
103 | |
85 | |
70 |