Forum Discussion

Jaweed's avatar
Jaweed
Helper III
5 years ago
Solved

Retrieving 2 selected dates in Date Slicer

Hi everybody I have been looking for the solution before coming to you. How do I get the 2 dates selected ina date slicer. The dates to be returned should not be the ones in the table, but the selec...
Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    Jaweed 

    It cannot be done with a single table. you need to create a date table and create a relationship. The measure to get the slicer date will be as follows. I attached a PBIX file.

    Start Date = 
CALCULATE(
    MIN('Table'[Date]),
    ALLEXCEPT('Table',Dates[Date])
)

---------------------------------------------

End Date = 
CALCULATE(
    MAX('Table'[Date]),
    ALLEXCEPT('Table',Dates[Date])
)

     

Fowmy's avatar
Fowmy
Super User
5 years ago

Jaweed 

It cannot be done with a single table. you need to create a date table and create a relationship. The measure to get the slicer date will be as follows. I attached a PBIX file.

Start Date = 
CALCULATE(
    MIN('Table'[Date]),
    ALLEXCEPT('Table',Dates[Date])
)

---------------------------------------------

End Date = 
CALCULATE(
    MAX('Table'[Date]),
    ALLEXCEPT('Table',Dates[Date])
)

 

Jaweed's avatar
Jaweed
Helper III
5 years ago

Thank you very much Fowmy