Maxdate need to select

[Anonymous]

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 colum.

My requirment is the slicer should show the max date value and as we select the dates in slicer the value should change.

Regards,

Rakesh

[Fowmy]

@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 🙂

YouTube  LinkedIn

[Anonymous]

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

[amitchandak · Accepted solution]

@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