cancel
Showing results for
Search instead for
Did you mean:

# For Loop Greg_Deckler
Super User
323 Views
Highlighted Super User

## For Loop

This is a demonstration on how to emulate a traditional For loop in DAX. For further explanation, see this article:

https://community.powerbi.com/t5/Community-Blog/For-and-While-Loops-in-DAX/bc-p/637511

```For Loop =
// Provide some starting values
VAR __n = 5
VAR __sum = 10
// Generate a "loop table", this will emulate a for loop for i=1 to some number
VAR __loopTable = GENERATESERIES(1,__n)
// Add in our calculated sum, emulating calculations done as iterations over the loop
VAR __loopTable1 = ADDCOLUMNS(__loopTable,"__sum",SUMX(FILTER(__loopTable,[Value]<=EARLIER([Value])),[Value]))
// Determine our MAX interation, the maximum value for "i"
VAR __max = MAXX(__loopTable1,[Value])
RETURN
// Return the value associated with the maximum value of "i" which is the last iteration in our "loop"
MAXX(FILTER(__loopTable1,[Value]=__max),[__sum])```

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!