Forum Discussion
Maxdate need to select
Date Status 08/08/2020 Inprogress 08/14/2020 Inprogress 08/21/2020 Delayed 08/30/2020 Completed I am using a card to display the status and I am using a slicer for the Date co...
Anonymous ,
There is no way default slicer using a function
You can create a column like
Switch(True(),
[Date] =max([Date]) , "Latest Date",
[Date]
)
sort this on date and use in slicer
Anonymous
Add a column to your table, it will give 1 and 0. Select the slicer and drag and drop the MaxDate field to the visual filter and set it equal to 1
MaxDate = CALCULATE( MAX(Data[Date]), ALLEXCEPT(Table1,Table1[Status]))
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
This is not working as I have multiple satus for same date.
| Date | Category | Status |
| 08/08/2020 | A | Started |
| 08/08/2020 | B | Delayed |
| 08/09/2020 | A | Started |
| 08/09/2020 | B | Started |
| 08/10/2020 | A | Completed |
| 08/10/2020 | B | Started |
| 08/11/2020 | A | Completed |
| 08/11/2020 | B | Completed |