Forum Discussion
DAX reference calculated column previous calculated value, different row, within self formula
Hi, I wonder if there is any way to reference a different (previous) calculated value within the same column in a different row within the general formula of the calculated column. When I try doi...
This may be of some help: Cthulhu - Microsoft Power BI Community
On a different post, I had a question about calculating cumulative consecutive values and I couldnt develop a solution my my own. User Greg_Deckler helped me out a lot by providing the link above. It invloves a method where by a temporary table is generated and then the calculated column references that table, which - at least in my case - gets around the circular reference issue. Maybe it will be helpful for you aswell?
Best of Luck.