min on dates row by row

[andrewb95]

I have some data with activities for two events. For the purpose of the explanaiton date 1 and date 2.  A user can complete either date 1 or date 2 or both. I want to populate the third column with the first date of these two actions. 

As you can see when a user has completed both using the following:   Min= MIN(Data.[Date1].[Date],Data[Date2].[Date])

However the issue is when one of the objects only has one value the min column does not populate... 

Example data set:

Date1	Date2	Min
01/02/2020		01/02/2020
02/02/2020	05/02/2020	02/02/2020
	08/02/2020	08/02/2020

Objects with a strikethrough currently don't appear due to blanks in other column. I need to be able to see the items with the strikethrough too. 

[amitchandak · Accepted solution]

@andrewb95 , Try without .date

Or try like

Switch(true(),
not(isblank(Data[Date1])) && not(isblank(Data[Date2])), min(Data[Date1],Data[Date2]),
isblank(Data[Date1]) ,Data[Date2]
isblank(Data[Date2]),Data[Date1])