Forum Discussion

lscoffield's avatar
lscoffield
Frequent Visitor
7 years ago

Create a new table with latest row

  I have a table that records activities session_id and a timestamp. (see diagram) I would like to create a table with only the latest entry for each session_id. The rows marked in yellow. Can someo...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi lscoffield,

 

You also can add create a measure and add it in the Visual Level filter and filter out the blanks.

Measure =
VAR maxTimeStamp =
    CALCULATE (
        MAX ( 'table'[timestamp] ),
        ALLEXCEPT ( 'table', 'table'[session_id] )
    )
RETURN
    IF ( MIN ( 'table'[timestamp] ) = maxTimeStamp, 1, BLANK () )

Best Regards,

Dale