topic Re: Last Value for multiple Items in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Last-Value-for-multiple-Items/m-p/1207487#M19410 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="243301" data-lia-user-login="RicardoXavier" class="lia-mention lia-mention-user">RicardoXavier</a>&nbsp;- See Lookup Min/Max pattern here:&nbsp;<A href="https://community.powerbi.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/m-p/985814#M434" target="_blank">https://community.powerbi.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/m-p/985814#M434</A></P> Tue, 07 Jul 2020 21:32:22 GMT Greg_Deckler 2020-07-07T21:32:22Z Last Value for multiple Items https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Last-Value-for-multiple-Items/m-p/1207448#M19408 <P>Please I am trying to get the last value from one table that contains the following data:</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>In these table I want to get for&nbsp;</P><P>ITEM_NAME = ACAM-147HS</P><P>Last Date = 6/29/2020, <STRONG>colum WT_FCH</STRONG></P><P>Last Value =&nbsp; 140, <STRONG>colum WT_BFPD</STRONG></P><P>&nbsp;</P><P><STRONG>I've been using the following DAX, but I have these problem&nbsp;</STRONG></P><DIV><DIV><SPAN>Last Value = SUMMARIZECOLUMNS(Query2[ITEM_NAME],Query2[WT_BFPD], LASTNONBLANKVALUE(Query2[WT_FCH],Query2[WT_FCH]))</SPAN></DIV><DIV>&nbsp;</DIV><DIV>&nbsp;</DIV></DIV><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><P>&nbsp;</P><P>&nbsp;</P> Tue, 07 Jul 2020 21:08:31 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Last-Value-for-multiple-Items/m-p/1207448#M19408 RicardoXavier 2020-07-07T21:08:31Z Re: Last Value for multiple Items https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Last-Value-for-multiple-Items/m-p/1207487#M19410 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="243301" data-lia-user-login="RicardoXavier" class="lia-mention lia-mention-user">RicardoXavier</a>&nbsp;- See Lookup Min/Max pattern here:&nbsp;<A href="https://community.powerbi.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/m-p/985814#M434" target="_blank">https://community.powerbi.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/m-p/985814#M434</A></P> Tue, 07 Jul 2020 21:32:22 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Last-Value-for-multiple-Items/m-p/1207487#M19410 Greg_Deckler 2020-07-07T21:32:22Z