Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Single date slicer

Hi Friends,   I have a requirement where I have two date columns in one table ( Open date and Close date). I need to have a single date slicer, if I select the date the condition should apply to th...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

     

    According to your description, I think the solution I provided above is based on a separate calendar table as a slicer to interact with your fact table, and you need to ensure that there is no inter-table relationship between the two tables, because the relationship between the two tables is manually defined by me writing measures, after implementing this premise, I think my scheme can perfectly achieve your needs, and for the calendar type date slicer you mentioned, I think it's just that the type of slicer is different. The essence is the same, you can achieve the same effect by placing the date column in the calendar table in your own slicer.

     

    Best Regards,

    Neeko Tang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

ppm1's avatar
ppm1
Solution Sage
3 years ago

You can create a disconnected table with a single column of date values and use that in your slicer. You can then get the SELECTEDVALUE() or MIN() of that column and use it in your FILTER in your measure.

 

Here is one way to generate that table with DAX.

 

SlicerDates = CALENDAR(MIN(Table[OpenDate]), MAX(Table[CloseDate]))

 

Pat