Finding the earliest date between two colomns

[MdJ83]

Im looking to identify the earliest date between the two colomns in the same row.

Example data

Input		Output
First Start	Second Start		Date
15/03/2021	15/09/2022		15/03/2021
17/03/2021	1/03/2021		1/03/2021

[v-rongtiep-msft · Accepted solution]

Hi @MdJ83 ,

Please have a try.

Create a column.

Column =
VAR first_date = 'Table'[First Start]
VAR second_date = 'Table'[Second Start]
RETURN
    IF ( first_date > second_date, second_date, first_date )

Or a measure.

Measure =
VAR start_1 =
    MAX ( 'Table'[First Start] )
VAR second_2 =
    MAX ( 'Table'[Second Start] )
RETURN
    IF ( start_1 > second_2, second_2, start_1 )

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Jihwan_Kim]

Hi,

Please check the below picture and the attached pbix file.

it is for creating a new table.

Output Table =

SELECTCOLUMNS ( Input, "Date", MIN ( Input[First Start], Input[Second Start] ) )

[MdJ83]

Thanks that worked and thanks for showing me the min fucntion. I just tweaked it not to create a new table

MIN ( Input[First Start], Input[Second Start] ) )