Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi all,
I need to plot a chart for which I should perform a 3 set of nested loops. The logic is elaborated a bit in detail in below image.
The plot should be arrSum vs KW.
Is there any Idea how to translate it to DAX? I read some posts on how to build nested loops with EARLIER, but first I could not use them for this piece of code, and second using EARLIER function does not pop up any intellisense to pick the right column. Therefor I suspected the formula and could not bring it to an end. What I could sofar figure out, is that I can from the above syntax probably I can omit the most outer For loop in DAX and replace it with having KW as the X axis.
@madhas See if this helps: For Loop - Microsoft Power BI Community
@Greg_Deckler Thanks, that was helpful but did not solve my problem. Do you have something also for nested loops? I can't figure out how to pass some parameters between loops using this method.