Forum Discussion

jneuey5's avatar
jneuey5
Frequent Visitor
3 years ago

Multiple Dates in a Row

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 Earl...
DAX
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi jneuey5 

try like:

Column = 
MAX(
   [date1],
   MAX(
        [date2],
        MAX(
            [date3],
            MAX([date4], [date5])
        )
     )
)