Forum Discussion

masterl1983's avatar
masterl1983
Frequent Visitor
8 years ago

Get most recent records

Hi,   I have a table (actually a CosmosDB) where each document/record represents the location (Latitude/Longitude) of a device at a specific DateTime.   DateTime Device ID Longitude Latitude ...
v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
8 years ago

hi,@masterl1983

    Thank you for your reminding, I've improved my formula

new latest DateTime  = IF(CALCULATE(MAX(Table2[DateTime ]),FILTER (
            Table2,
            Table2[Device ID] = EARLIER ( Table2[Device ID] )
                && Table2[DateTime ]>=EARLIER ( Table2[DateTime ]  )
        ))=Table2[DateTime ],Table2[DateTime ])

Result:

Best Regards,

Lin