topic Re: Dax Measure to Specify which rows correspond to last change in DAX Commands and Tips

Dax Measure to Specify which rows correspond to last change

lazurens2 — Wed, 21 Sep 2022 13:55:36 GMT

Hello,

I have this example please

Expected output : a Measure that returns 1 for a = 3 / b = 6
These are verions and I need to specify which one is the last version

I tried this, the measure isn't even working because it couldn't find `_LastChange`

Best Score 2 = VAR _LastChange = SUMMARIZECOLUMNS('Table'[Column1], "Maxd", Max('Table'[Column2]) ) VAR _group = VALUES('Table'[Column1]) VAR _max = _LastChange[Maxd] Return VAR MaxValue = CALCULATE ( MAX ( 'Table'[Column2] ), REMOVEFILTERS ( 'Table' ) ) RETURN IF ( SELECTEDVALUE ( 'Table'[Column1] ) = _group, IF(Filter('Table', 'Table'[Column1] = _group) = _max , 1, 0 ) )

Thank you in advance

Re: Dax Measure to Specify which rows correspond to last change

tamerj1 — Wed, 21 Sep 2022 14:18:08 GMT

Hi lazurens2

do you want to flag the last record of each value of column1? If so please try

Best Score 2 = VAR CurrentValue = SELECTEDVALUE ( 'Table'[Column2] ) VAR MaxValue = CALCULATE ( MAX ( 'Table'[Column2] ), ALLEXCEPT ( 'Table', 'Table'[Column1] ) ) RETURN IF ( CurrentValue = MaxValue, 1 )

Re: Dax Measure to Specify which rows correspond to last change

lazurens2 — Thu, 22 Sep 2022 06:02:07 GMT

Thank you very much, it's working !