Show in card last value of a date

[Tobias106]

Hello,

my calender goes until 31.12.2024.

My last value in column A = 12345 (this is on 16.11.2022). 17.11.2022 and so on is empty.

Now I want to show in the card always the value of the last date, with a value. 

Any ideas with a measure?

Thank you

Tobias

[v-jingzhang · Accepted solution]

Hi @Tobias106

You can try this measure. Change the table name accordingly. 

Measure = 
var _lastDate = MAXX(FILTER('Table (5)',NOT(ISBLANK('Table (5)'[Value]))),'Table (5)'[Date])
return
MAXX(FILTER('Table (5)','Table (5)'[Date]=_lastDate),'Table (5)'[Value])

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[mariussve1]

Hi,

Do you have a Date table ( marked as datetable ) in your model? This is recommended and best practice.

Then you could use:

CALCULATE ( [Measure], LASTDATE( 'Date'[Date] ) )

Br

Marius