Forum Discussion
DAX reference calculated column previous calculated value, different row, within self formula
I don’t think we can do it with DAX. We can use EARILER to reference previous values in others existing columns but cannot do the same thing in self calculated column.
In your above DAX formula, Table1[Peak] is referenced in the Peak formula, this will causes a circular dependency. You can take a look at this article which talks about the circular dependencies.
Best Regards,
Herbert
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
Hi jrojasuk , v-haibl-msft
I have a similar issue: I need to get the classification of a customer on a previous date, to determine the current classification.
Thus, it should be possible to fetch that using a filtered version of the current column, since it is a completely different row context.
Have you managed to find a solution yet?
Thanks