topic Re: Multiple Dates in a Row in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Multiple-Dates-in-a-Row/m-p/3061177#M105770 <P>hi <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="287961" data-lia-user-login="jneuey5" class="lia-mention lia-mention-user">jneuey5</a>&nbsp;</P><P>try like:</P><DIV>Column =&nbsp;</DIV><DIV>MAX(</DIV><DIV>&nbsp; &nbsp;[date1],</DIV><DIV>&nbsp; &nbsp;MAX(</DIV><DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[date2],</DIV><DIV>&nbsp; &nbsp; &nbsp; &nbsp; MAX(</DIV><DIV>&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[<SPAN>date3</SPAN>],</DIV><DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MAX(<SPAN>[</SPAN><SPAN>date4</SPAN><SPAN>], [</SPAN><SPAN>date5</SPAN><SPAN>]</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;)</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp;&nbsp;&nbsp;)</SPAN></DIV><DIV>)</DIV> Fri, 03 Feb 2023 22:41:24 GMT FreemanZ 2023-02-03T22:41:24Z Multiple Dates in a Row https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Multiple-Dates-in-a-Row/m-p/3060992#M105755 <P>Hello,&nbsp;<BR /><BR />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</P><P><BR />Thanks<BR /><BR /><BR /></P> Fri, 03 Feb 2023 19:43:50 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Multiple-Dates-in-a-Row/m-p/3060992#M105755 jneuey5 2023-02-03T19:43:50Z Re: Multiple Dates in a Row https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Multiple-Dates-in-a-Row/m-p/3061177#M105770 <P>hi <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="287961" data-lia-user-login="jneuey5" class="lia-mention lia-mention-user">jneuey5</a>&nbsp;</P><P>try like:</P><DIV>Column =&nbsp;</DIV><DIV>MAX(</DIV><DIV>&nbsp; &nbsp;[date1],</DIV><DIV>&nbsp; &nbsp;MAX(</DIV><DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[date2],</DIV><DIV>&nbsp; &nbsp; &nbsp; &nbsp; MAX(</DIV><DIV>&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[<SPAN>date3</SPAN>],</DIV><DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MAX(<SPAN>[</SPAN><SPAN>date4</SPAN><SPAN>], [</SPAN><SPAN>date5</SPAN><SPAN>]</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;)</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp;&nbsp;&nbsp;)</SPAN></DIV><DIV>)</DIV> Fri, 03 Feb 2023 22:41:24 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Multiple-Dates-in-a-Row/m-p/3061177#M105770 FreemanZ 2023-02-03T22:41:24Z