Forum Discussion
Row formulas in Table
Hi, in my previous post I found out how to allocate a row number for each row in table. There will be a maximum of 30 rows. Is it possible to allocate a different formula to a different row? Someth...
PBE Well, more or less that is what the pattern in the article is doing. Essentially you are adding a column to the table for each recursive iteration. By doing this, you effectively avoid recursion within a single column which DAX does not like, it just makes it a complete pain to code and requires a reasonable maximum approach. Could it also be done as 30 measures instead of 30 columns in a table. Sure. But I'm not sure that is really any better and would likely be more of a pain to manage since the code would be split between 30 measures versus all in a single measure.