https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Latest-confirmed-date-depending-on-the-product/m-p/1919885#M41612 <P>Here's the DAX for a calculated column to get your desired result</P><P>&nbsp;</P><DIV><DIV><SPAN>Latest Date = </SPAN></DIV><DIV><SPAN>CALCULATE(</SPAN></DIV><DIV class="lia-indent-padding-left-30px"><SPAN>MAX(Products[Confirmation date]),</SPAN></DIV><DIV class="lia-indent-padding-left-30px"><SPAN>ALLEXCEPT(Products, Products[Product])</SPAN></DIV><DIV><SPAN>)</SPAN></DIV></DIV> Thu, 24 Jun 2021 11:34:17 GMT PaulOlding 2021-06-24T11:34:17Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Latest-confirmed-date-depending-on-the-product/m-p/1919764#M41607 <P>Hello people,</P><P>&nbsp;</P><P>I need a column that gives me the latest confirmed date depending on the product.<BR />Does anyone of you have an idea how to implement this, below I have created a small example.</P><P>Thanks in advance!</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Product</TD><TD>Confirmation date</TD><TD>latest Date</TD></TR><TR><TD>1</TD><TD>06/16/21</TD><TD>06/24/21</TD></TR><TR><TD>1</TD><TD>06/18/21</TD><TD>06/24/21</TD></TR><TR><TD>1</TD><TD>06/24/21</TD><TD>06/24/21</TD></TR><TR><TD>2</TD><TD>06/17/21</TD><TD>06/22/21</TD></TR><TR><TD>2</TD><TD>06/22/21</TD><TD>06/22/21</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>with kind regards<BR />Lukas</P> Thu, 24 Jun 2021 10:22:02 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Latest-confirmed-date-depending-on-the-product/m-p/1919764#M41607 Anonymous 2021-06-24T10:22:02Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Latest-confirmed-date-depending-on-the-product/m-p/1919885#M41612 <P>Here's the DAX for a calculated column to get your desired result</P><P>&nbsp;</P><DIV><DIV><SPAN>Latest Date = </SPAN></DIV><DIV><SPAN>CALCULATE(</SPAN></DIV><DIV class="lia-indent-padding-left-30px"><SPAN>MAX(Products[Confirmation date]),</SPAN></DIV><DIV class="lia-indent-padding-left-30px"><SPAN>ALLEXCEPT(Products, Products[Product])</SPAN></DIV><DIV><SPAN>)</SPAN></DIV></DIV> Thu, 24 Jun 2021 11:34:17 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Latest-confirmed-date-depending-on-the-product/m-p/1919885#M41612 PaulOlding 2021-06-24T11:34:17Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Latest-confirmed-date-depending-on-the-product/m-p/1919931#M41614 <P>&nbsp;</P><P><A href="https://www.dropbox.com/s/6q26n6n2gpl17c3/keluv3.pbix?dl=0" target="_self">https://www.dropbox.com/s/6q26n6n2gpl17c3/keluv3.pbix?dl=0</A>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P><STRONG><EM>Latest date CC =</EM></STRONG><BR /><EM>MAXX (</EM><BR /><EM>FILTER ( 'Table', 'Table'[Product] = EARLIER ( 'Table'[Product] ) ),</EM><BR /><EM>'Table'[Confirmation date]</EM><BR /><EM>)</EM></P> Thu, 24 Jun 2021 11:51:05 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Latest-confirmed-date-depending-on-the-product/m-p/1919931#M41614 Jihwan_Kim 2021-06-24T11:51:05Z