Show data only latest date in Card visualizations

[Anonymous]

Hi All,

Please help me with how to display the latest values in Card visualizations for all columns. I have created a card visual for all columns individually. If I select the 31st Mar date, the value does not display selected date value in all visuals. 

Date	Inc	SR	Ch	Ct	Pr	Req	Inct%	Srs%	Att	Nor%	Count
30/03/2020	0	0	0	0	8	132	6.50%	1.67%	0	100%	0
31/03/2020	0	0	0	0	5	138	2.13%	2.89%	0	100%	0

[amitchandak · Accepted solution]

@Anonymous 

Create Measure like this

Measure1 =
var _max = maxx(Table,Table[Date])
return
calculate([Measure],filter(Table,Table[Date] =_max))

Or Create a flag in your table as column

Flag Column=
var _max = maxx(Table,Table[Date])
return
If(Table[Date] =_max,1,0)

Use this to filter the data

[CCASTRO]

Hello, in your expression what value are you using as measure?

calculate([Measure],filter(Table,Table[Date] =_max))

[allwynbazil]

Hi @amitchandak, 

What do you mean by measure in your formula below?

Measure1 =
var _max = maxx(Table,Table[Date])
return
calculate([Measure],filter(Table,Table[Date] =_max))

I am trying to pull the progress for the latest date in the card visual. However am not getting how to get it.

Please help.