How to select the last value of the day (having date/time) with DAX in Power BI

[axk180022]

I need to only filter the last value of the day, for example 9/25/2020 has 2 values so I need to find the latest based on the time.

can someone please tell me the DAX Expression.

I need the final table to look like above with just 1 value from each date or day.

@Greg_Deckler , @selimovd , @amitchandak , @Fowmy 

[v-luwang-msft · Accepted solution]

Hi @axk180022 ,

Base data according your picture:

Try the following measure:

TEST = 
VAR TEST =
    CALCULATE (
        MAX ( 'Table'[Time] ),
        FILTER (
            ALL ( 'Table' ),
            FORMAT ( 'Table'[Time], "yyyymmdd" )
                = FORMAT ( MAX ( 'Table'[Time] ), "YYYYMMDD" )
        )
    )
RETURN
    IF (
        CALCULATE (
            MAX ( 'Table'[GENERATORHOURS] ),
            FILTER ( ALL ( 'Table' ), 'Table'[Time] = TEST )
        )
            <> MAX ( 'Table'[GENERATORHOURS] ),
        BLANK (),
        CALCULATE (
            MAX ( 'Table'[GENERATORHOURS] ),
            FILTER ( ALL ( 'Table' ), 'Table'[Time] = TEST )
        )
    )

Final get :

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Best Regards

Lucien

[axk180022]

It should take the last date/time of that day for each inventserialid. 

@parry2k 

[parry2k]

@axk180022 last date/time for the whole table or the last date/time for each serial?