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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

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

the calender one works thank you

Yqy_0-1677736958424.png

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors