Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

FOR loop equivalent in DAX?

Hi all,   I'm looking to get feedback on how I could acheive something similiar to a loop in DAX. I'm familiar with SWITCH and already using it (as you can see in the code below) however I'm faced ...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Greg_Deckler I'll take a look.

 

Does this mean you don't think I'm crazy, and there is a ray of hope?

 

Thanks,

-R

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago
    Well, I wrote a blog article on how to emulate a FOR loop and a WHILE loop in DAX. Also an article on emulating recursion. You're not crazy.
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Greg_Deckler ,

       

      Read through the blog post, generally makes sense without going and writing my own.

       

      In thinking my situtation through though, I think I'm still stuck...

       

      Using your approach here is how I think it would play out for me.

       

      I have a table with an index that by virtue of its columns defines all the various combinations (rows). Using your approach we would iterate through each row, and for each row I could use the MAXX formulas to find the values for those rows (my conditions). Great, now I could say "do X" for this particular condition, and I didn't have to spell out each condition. Where I think I'm going to get stuck though is the "do X" I want is to assign a specific measure to that condition and I don't see a way to (through logic) specifiy use this Measure for this condition unlees there is a clever way to just add a bunch of measures to a single column in table and index it, then I would be able to say for Index 1 of my first table, match that to Index 1 of the Measure Table. The whole intent of this execise is to align each unique measure to the particular row so that I can then proceed to carry out more "normal" tabular calculations like sums, divides, multiplies, etc.

       

      Am I missing something?