Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Yqy
Helper I
Helper I

Get date from other table columns

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

Yqy_0-1677633636560.png

 

2 ACCEPTED SOLUTIONS
amitchandak
Super User
Super User

@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]) )

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

the calender one works thank you

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@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]) )

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

the calender one works thank you

Yqy_0-1677736958424.png

 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!