Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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. 🙏
Solved! Go to 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!
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!
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |