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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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