Forum Discussion
Referencing Previous Column and Row using Measures in Power Pivot
Hello, I am currently trying to create a measure (in Power Pivot and Power Query) that will allow me to reference a different row and column from the one I am currently working on (see question at v...
Hello lbendlin ,
Thank you for your help and for the explaination!
I have updated my spreadsheet to reflect the new information. (Please see below screenshot).
Also, by "cumulative calculation," do you mean something like the EARLIER function? That is how I have set up my measures so far.
Once again, I would appreciate your help and any feedback you can provide on how to update my current measures!
Thanks!
lbendlin
Super User
Super UserThe use of EARLIER is discouraged. Instead, use variables to protect your results from filter context transitions.
But - if it works for you then go with it.