How to display latest data on cards and gauge

[kiranbchitari]

Hi,

I am getting data from the IoT devices and I am dumping those data to the cosmos Db every 5 min. And I have connected the cosmos Db to power bi through inbuilt power bi connector. So every 5 min I am getting new data, it also has a date and time column. Now, how can I show the latest data(Latest data sent to cosmos) based on the time on the cards and gauge?

Thanks

[v-frfei-msft · Accepted solution]

Hi @kiranbchitari,

To create a measure to display the latest date using the formula.

latest date = CALCULATE(MAX(your table[date]),ALL(your table))

Regards,

Frank

[v-frfei-msft]

Hi @kiranbchitari,

Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

Regards,
Frank