Multiple Dates in a Row

Question

Hello,&nbsp;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 columnsThanks

freemanz · Answer

hi jneuey5&nbsp;try like:Column =&nbsp;MAX(&nbsp; &nbsp;[date1],&nbsp; &nbsp;MAX(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[date2],&nbsp; &nbsp; &nbsp; &nbsp; MAX(&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[date3],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MAX([date4], [date5])&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;)&nbsp; &nbsp;&nbsp;&nbsp;))

Forum Discussion

Multiple Dates in a Row

1 Reply

Related content

Multiple Date Fields

Multiple date row data

Issue with Formulas - When Multiple Rows Similar Rows Exist

How to use latest date from multiple rows for visualization

Rows - Maximum Date