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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
sam888
Frequent Visitor

How to get earlier date across 2 columns?

Hi all,

I am wondering if someone can help me with this. I have these 2 date columns, I am looking for a way to retrieve the earlier of 2 dates in a new column.

thanks

 

sam888_0-1670818532607.png

 

1 ACCEPTED SOLUTION

@sam888 

aha =, then try 

= MIN(MIN('deal'[close_date]), MIN('tier'[deal_close_date]))

View solution in original post

3 REPLIES 3
FreemanZ
Super User
Super User

try this

 

= MIN([close_date], [deal_close_date])

thanks I forgot to mention they are from 2 different tables. When I try your solution, I get this error

 

sam888_0-1670823292361.png

 

@sam888 

aha =, then try 

= MIN(MIN('deal'[close_date]), MIN('tier'[deal_close_date]))

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.