Get date from other table columns

[Yqy]

I need the earliest start date and latest end date from two different columns and put them as date range

[amitchandak · Accepted solution]

@Yqy , If you need a two columns

Min(Table[Start])

Max(Table[End])

If you need as two measures

Minx(allselected(Table) , Table[Start])

Maxx(allselected(Table) ,Table[End])

If you want default a range based slicer , create a calendar with those date, I doubt you can initialize range based slicer

calendar(

Min(Table[Start]) , Max(Table[End]) )

[amitchandak · Accepted solution]

@Yqy , If you need a two columns

Min(Table[Start])

Max(Table[End])

If you need as two measures

Minx(allselected(Table) , Table[Start])

Maxx(allselected(Table) ,Table[End])

If you want default a range based slicer , create a calendar with those date, I doubt you can initialize range based slicer

calendar(

Min(Table[Start]) , Max(Table[End]) )

[Yqy · Accepted solution]

the calender one works thank you

[Yqy]