Card visual last value with date slider filters

[BurgerBI]

Hi All,

Appreciate your help.

This is my dataset

Date	No. of Customers
01/01/2024	1000
02/01/2024	1500
03/01/2024	2000
04/01/2024	2500
05/01/2024	3000
06/01/2024	3500
07/01/2024	4000
08/01/2024	4500
09/01/2024	5000

I'm using the date slider filter. 

I want to use a card visual to show the last date value. In other words, if the date slider filter is set between 05/01/2024 - 07/01/2024, the card visual should show 4000. if it's set 01/01/2024 - 04/01/2024, the card visual should show 2500.

I've tried, CALCULATE(MAX(No. of Customers), Date = MAX(Date[Date])) and CALCULATE(MAX(No. of Customers), LASTDATE(Date[Date])). Both still shows the latest value which is 5000, regardless of what the date slider is set to.

Thanks for your help. 🙏

[v-jingzhan-msft · Accepted solution]

Hi @BurgerBI 

Did you create a measure rather than a new column with the formula? This should work with a measure. If it's a column, it won't work. 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!