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]; '...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 

Try this measure

 

maxbi =
VAR md =
    MAX ( 'TI'[Date] )
RETURN
    CALCULATE (
        MAX ( 'TI'[Date] ),
        FILTER (
            ALL ( 'TI' ),
            'TI'[Assignment group]
                = MAX ( 'TI'[Assignment group] )
                && 'TI'[Date] < md
        )
    )

 

 

Regards,

Harsh Nathani