Forum Discussion
Row formulas in Table
PBE So most likely not, at least not in any acceptable form that you are probably going to want to deal with. Although, with 30 rows maximum it could, in theory, be possible. The reason is that there is a recursive element to this code for Backfill and DAX hates recursion with a passion. Previous Value (“Recursion”) in DAX - Microsoft Fabric Community
Thanks again Greg_Deckler for your help. Is it possible I could calculate the answer separate from a table. I'm guessing here, perhaps allocate RN1 Work, RN1 Service and RN1 Backfill as the variables and the same for RN 2 work etc. Then use these variables to calculate the answer for each row.
Such as Formula 1 = RN1 Work - RN1 Service = answer 1
Formula 2 = RN2 Work - (RN1 Service + RN2 Service) = answer 2
Then say display answer 1 in card 1 and answer 2 in card 2 etc.
The part I definitely don't know is how to make RN1 Work and RN 1 Service into variables and use these in a formula.
Any ideas?
