How to get Top Date selection of a Slicer

[Anonymous]

I was asked to try to calculate the number of days between a date in a table and the higher date in a slicer.

Is this possible?

I manage to get the dates present in the slicer, by using a measure with values. But I can not get the MAX to calculate the diference.

Thanks

[Greg_Deckler]

Would need to see a sample of your data and how you are using it.

[Anonymous]

@Greg_Deckler

In this example the idea is to get the difference between each Start Date and in this example: 27-02-2017. In the case that the End Date is empty.

[cs_skit]

Did not do this with Dates but with some other thing recently

Selected Duck + Details = IF(COUNTROWS(ALLSELECTED(Ducks))=1, LOOKUPVALUE(Ducks[Duck Number],Ducks[Duck Number and Details],
ALLSELECTED(Ducks[Duck Number and Details])),"default duck details")

Can't share the thing as its customer data so I replaced it with Ducks.

No idea if this is of any help to you but sounded kind of similar.