Date slicer set min and max date or set date slicer range based on date column

[prvn]

I have a dimcalendar table with date range from 2018 - 2021. I have a transaction table the has relation to this dim calendat table on date. I have created a date slicer from dimcalendar table. The slicer by default is set to 2018 as start and 2021 as end.

How do i make the this splitter have range from the transaction table.

Note: I don't want to create a date splitter from transaction table. 

Cheers,

prvn

[Johanno · Accepted solution]

Hi,

1. Can't you change the slicer to point to the transaction dates instead?

2. Or alternatively use as calendar table:

Dates = CALENDARAUTO(12)

to avoid having the Dimcalendar table go so far.

3. Another workaround could be creating a new date column in the Dimcalendar which exludes dates that's in the future from the transaction table:

Dates without future = IF(Dates[Date]<MAX(Table1[Date]);Dates[Date])

and then point the slicer to this column instead.

/Johan