Filter last date value for each item in a Table in DAX

[montibellin]

Hello,

how can filter for each item the last value by date?

thank you for you help

[VahidDM]

Hi @montibellin 

Try to create a measure with this code and add that to the table with Item and Value:

Last Value =
VAR _Ldate =
    LASTDATE ( 'Table'[Date] )
RETURN
    IF (
        CALCULATE ( MAX ( 'Table'[Date] ), ALLEXCEPT ( 'Table', 'Table'[Item] ) ) = _Ldate,
        _Ldate,
        BLANK ()
    )

Output:

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Appreciate your Kudos✌️!!

[montibellin · Accepted solution]

Dear VahidDM,

there's some problem with date duplicate.

I've resolved with this code:

Measure =

VAR maxd =

CALCULATE (

MAX ( Table[Time]),

ALLSELECTED ( Table ),

VALUES ( Table[Item])

)

RETURN

IF ( MAX ( Table[Time] ) = maxd, 1, BLANK () )

[Greg_Deckler]

@montibellin Use Lookup Min/Max: Lookup Min/Max - Microsoft Power BI Community

[montibellin]

Thanks Greg but I don't need to summarize the values of each items. the result table must contain the value related to the last date.