topic Re: Product at the last date by a product in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Product-at-the-last-date-by-a-product/m-p/3244840#M119486 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="472422" data-lia-user-login="Margreet" class="lia-mention lia-mention-user">Margreet</a>&nbsp;</P> <P>Please try</P> <P>LastProduct =<BR />MAXX ( TOPN ( 1, 'Table', 'Table'[Date] ), 'Table'[Product] )</P> Fri, 19 May 2023 18:35:58 GMT tamerj1 2023-05-19T18:35:58Z Product at the last date by a product https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Product-at-the-last-date-by-a-product/m-p/3244710#M119478 <P><img /></P><P>&nbsp;</P> Fri, 19 May 2023 16:43:41 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Product-at-the-last-date-by-a-product/m-p/3244710#M119478 Margreet 2023-05-19T16:43:41Z Re: Product at the last date by a product https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Product-at-the-last-date-by-a-product/m-p/3244783#M119481 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="472422" data-lia-user-login="Margreet" class="lia-mention lia-mention-user">Margreet</a>&nbsp;</P> <P>&nbsp;</P> <P>MaxDate_nr = MAX ( 'Table'[date] )</P> <P>&nbsp;</P> <P>LastProduct =&nbsp;</P> <P>VAR MaxDate = [<SPAN>MaxDate_nr]<BR />RETURN</SPAN></P> <P><SPAN>CALCULATE ( MAX ( 'Table'[Product] ), KEEPFILTERS ( 'Table'[Date] = MaxDate ) )</SPAN></P> <P>&nbsp;</P> Fri, 19 May 2023 17:39:47 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Product-at-the-last-date-by-a-product/m-p/3244783#M119481 tamerj1 2023-05-19T17:39:47Z Re: Product at the last date by a product https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Product-at-the-last-date-by-a-product/m-p/3244821#M119484 <P><img /></P><P>&nbsp;</P> Fri, 19 May 2023 18:16:23 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Product-at-the-last-date-by-a-product/m-p/3244821#M119484 Margreet 2023-05-19T18:16:23Z Re: Product at the last date by a product https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Product-at-the-last-date-by-a-product/m-p/3244840#M119486 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="472422" data-lia-user-login="Margreet" class="lia-mention lia-mention-user">Margreet</a>&nbsp;</P> <P>Please try</P> <P>LastProduct =<BR />MAXX ( TOPN ( 1, 'Table', 'Table'[Date] ), 'Table'[Product] )</P> Fri, 19 May 2023 18:35:58 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Product-at-the-last-date-by-a-product/m-p/3244840#M119486 tamerj1 2023-05-19T18:35:58Z Re: Product at the last date by a product https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Product-at-the-last-date-by-a-product/m-p/3244851#M119487 <P><img /></P><P>&nbsp;</P> Fri, 19 May 2023 18:44:37 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Product-at-the-last-date-by-a-product/m-p/3244851#M119487 Margreet 2023-05-19T18:44:37Z Re: Product at the last date by a product https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Product-at-the-last-date-by-a-product/m-p/3244972#M119494 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="317289" data-lia-user-login="tamerj1" class="lia-mention lia-mention-user">tamerj1</a>&nbsp;</P><P>You are really a genius !!</P><P>&nbsp;</P> Fri, 19 May 2023 20:38:49 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Product-at-the-last-date-by-a-product/m-p/3244972#M119494 Ajendra 2023-05-19T20:38:49Z