Dataset with multiple date fields

[Anonymous]

I have a dataset with multiple date fields. Is there a way for me to filter all the dates with just a single slicer object instead of having a unique slicer for each date?

[Tahreem24]

@Anonymous You need to create a table like below:

Date Table = CALENDAR(MIN(Table[DateField 1]),MAX(Table[DateField 2]))

Then join this table with your date column.

[amitchandak · Accepted solution]

@Anonymous , yes join all dates with one date table. For inactive join, create measure with help from userelationship

example

calculate( SUM(Sales[Sales Amount]),USERELATIONSHIP ('Table'2[CreateDate], 'Date'[Date]))

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in-power-bi

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970