Multiple Dates in a Row

[jneuey5]

Hello, 

I'm trying to get the earliest date in a row that has five different dates and or blanks. Is there a way through DAX or M to get this date into it's own column. It appears Earlier and Earliest only work on columns

Thanks

[FreemanZ]

hi @jneuey5 

try like:

Column = 

MAX(

   [date1],

   MAX(

        [date2],

        MAX(

            [date3],

            MAX([date4], [date5])

        )

     )

)