Show Latest Record that is available in the table

[mrbuttons07]

Hello everyone,

Good day to you.

I have a data model that looks like something below.

The data is keyed in by user upon their time and availability. Is it possible to have the visuals to show the latest records from the data model? The visual should be showing Monday 1st January 2024 data as that's the latest data that was keyed in by the user.

Thanks!

[v-yiruan-msft · Accepted solution]

Hi @mrbuttons07 ,

I created a sample pbix file(see the attachment), please check if that is what you want.

1. Create a measure as below

Flag = 
VAR _seldate =
    SELECTEDVALUE ( 'Table'[Date] )
VAR _latestdate =
    CALCULATE (
        MAX ( 'Table'[Date] ),
        FILTER ( ALLSELECTED ( 'Table' ), NOT ( ISBLANK ( 'Table'[MUV (Actual)] ) ) )
    )
RETURN
    IF ( _seldate = _latestdate, 1 )

2. Create a table visual and apply a visual-level filter with the condition (Flag is 1)

Best Regards