Select only the latest value in gauge chart based on latest time

[Anonymous]

Hi all,

I have a set of values and I would like to select only the latest value based on the timestamp created.

The latest value can go as deep as 0.01 seconds of difference.

And also when I want to show the value in gauge, there is no option for me to show the latest value of generation only. Instead there are only options for sum, average and etc.

[v-shex-msft]

Hi @Anonymous ,

Please add index column to your table, then you can use current datetime and index fields to find out last records.

Measure =
VAR currDT =
    MAX ( Table[CreatedTimestamp] )
VAR _lastId =
    CALCULATE (
        MAX ( Table[Index] ),
        FILTER ( ALLSELECTED ( Table ), [CreatedTimestamp] = currDT )
    )
RETURN
    CALCULATE (
        MAX ( Table[Generation] ),
        FILTER (
            ALLSELECTED ( Table ),
            [CreatedTimestamp] = currDT
                && [Index] = _lastId
        )
    )

Regards,

Xiaoxin Sheng

[Anonymous]

I have a list of IDs and I want to show the latest value for every ID, how can I do it?

Appreciate your help, thanks. @v-shex-msft 

And I want to show every latest value in gauge chart as seen below:

[v-shex-msft · Accepted solution]

Hi @Anonymous ,

You can use following calculate column formula to mark last date for each id:

Is Last =
VAR currID = Table[ID]
VAR _lastdate =
    CALCULATE (
        MAX ( Table[CreateTimestamp] ),
        FILTER ( ALL ( Table ), [ID] = EARLIER ( Table[ID] ) )
    )
RETURN
    IF ( [CreateTimestamp] = _lastdate && [ID] = currID, "Y" )

For gauge chart, you can add a filter on visual level to display matched records.

Regards,

Xiaoxin Sheng