Table Visualization - show most recent date

[jerryr125]

Hi - 

I have the following Table visualization:

Date	Location	Quantity
1/20/2021	ABC	500
2/14/2021	ABC	2000
3/1/2021	DEF	3000
3/8/2021	DEF	4000

I would like to Table visualization to only display the most recent date by location.

Therefore, given the example above, the visualization should display the following:

Date	Location	Quantity
2/14/2021	ABC	2000
3/8/2021	DEF	4000

thoughts ? Thanks - Jerry

[salonicdk28]

Try this-

Dimension- Location

Measure-

Date=Date(Max(Date))

Quantity=FirstSortedValue(Quantity,-(Date*1000+Quantity))

[jerryr125]

Hi that did not work unfortunately - It is still displaying multiple dates for each location.

[salonicdk28 · Accepted solution]

You just need to take only Location as Dimension and other 2 fields will come in expression

1) Date should be calculated in expression as Date(Max(Date))

2)Quantity=FirstSortedValue(Quantity,-(Date*1000+Quantity))

Please try this way, Hope you get the result