How to get earlier date across 2 columns?

[sam888]

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

[FreemanZ]

try this

= MIN([close_date], [deal_close_date])

[sam888]

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

[FreemanZ · Accepted solution]

@sam888 

aha =, then try 

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