Show latest timestamp/data in card

[MRN8840]

Hi!

I have a dataflow which feeds me with data from energymeters (water, heat, electricity) once a day. Sometimes the flow fails and my data is two days old. Hence my reports have 'old' data. Is it possible to make a card with the latest timestamp of my data?

My data looks like this:

Måler_ID: Tag of the specifik meter (I have 62 meters with hourly consumption-readings)

Aflæsning_start: Timestamp beginning of reading

Aflæsning_slut: Timestamp ending of reading

Aflæsning: Conspumption ([Aflæsning_slut]-[Aflæsning_start])

Enhed: Unit - MWh (heat), m3 (water), KWh (electricity)

Aflæsningsdøgn: Date of reading, a calculated coloumn from [Aflæsning_slut].

I want to make a card in my report which displays the latest/newest value in [Aflæsning_slut]. That will make it possible for the viewers of the report to know how 'fresh' the data is.

[amitchandak · Accepted solution]

maxx(table,[Aflæsning_slut])

[MRN8840]

Thanks for your answers!

An ekstra question:

What If I want to make a LASTDATE for each different meter ('Varme_161591', 'Vand_161592') etc. How would that look? 🙂

[rajulshah]

@MRN8840,

You can use the same measure in different cards and then can apply 'Visual Level Filter' to the cards.

[rajulshah]

Hello @MRN8840,

You can use the following DAX in measure:

Latest Date = LASTDATE([Aflæsning_slut])

And you can use this measure in a card.

Hope this helps.