DAX reference calculated column previous calculated value, different row, within self formula

Hi Herbert,

Yes, thanks again. I have already been through many of those 'circular references' discussions.

This is exactly why I posted here to see if anyone else knew of any 'undocumented feature' that would let me accomplish this.

In my case strictly speaking, given the unique key and the clearly resulting different row context, by definition, there should not be any circular reference at run time. It is simply rather lazily treated as such by the parser just because it is easier to implement. I doubt I am the only one doing this kind of thing.

The point is that I have a set of existing BI reports currently being done in Excel, and I want to move them to some other BI suite going forward. I have already done that with three other products so far and I was just starting with Power BI in order to evaluate its capabilities when I got stuck here. I know I can find a hack around all these sets of columns that use this type of formulas, but the effort is really not worth it here.

So, I guess I sit this one out for a few months until someone comes up with a structural 'fix'.

Thanks again.

Jose