Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Optimize MAXX

How can I find the maximum of previous rows with rescpect to the current row? currently I get a memory error when I run this DAX.    maxbi:= MAXX( FILTER( Allexcept('TI'; 'TI'[Assignment group]; '...
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

Put the max(date) in a variable to compute it only once

 

maxbi:= 
var md = MAX([date])
return MAXX(
    FILTER( Allexcept('TI'; 'TI'[Assignment group]; 'TI'[Type])
           ; [date] <= md )
; 'TI'[Stock])
Anonymous's avatar
Anonymous
Not applicable
6 years ago

I mean by that to calculate dates previous to the selected row date.