The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.