https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/LOOKUPVALUE-with-multiple-matches/m-p/2295886#M56590 <P>I would like to do like this picture:</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="WhatsApp Image 2022-01-21 at 11.59.25.jpeg" style="width: 327px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/659247i4F5E0376C041914B/image-size/large?v=v2&amp;px=999" role="button" title="WhatsApp Image 2022-01-21 at 11.59.25.jpeg" alt="WhatsApp Image 2022-01-21 at 11.59.25.jpeg" /></span></P><P>&nbsp;</P><P>I need to know sale date of each product, but grouped by collumns for each sale date : 1° sale date,&nbsp;2°&nbsp;sale date and 3°&nbsp;sale date.</P><P>&nbsp;</P><P>Thank you for your reply!</P> Fri, 21 Jan 2022 15:13:18 GMT gorikovsk21 2022-01-21T15:13:18Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/LOOKUPVALUE-with-multiple-matches/m-p/2295797#M56583 <P>I have two tables in Power BI</P><P>&nbsp;</P><P>1° Table: products and sales date&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Captura de Tela (112).png" style="width: 295px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/659217iF46DF2E8D3EE01B1/image-size/large?v=v2&amp;px=999" role="button" title="Captura de Tela (112).png" alt="Captura de Tela (112).png" /></span>&nbsp;</P><P>&nbsp;</P><P>2° Table: products ocurrency transactions date</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Captura de Tela (111).png" style="width: 197px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/659218i6B912AC9DC3BF6A5/image-size/large?v=v2&amp;px=999" role="button" title="Captura de Tela (111).png" alt="Captura de Tela (111).png" /></span></P><P>&nbsp;</P><P>I would like to input the Sale_Date of 2° table in each correspondet collumn of 1° table. If there's no sale, insert blank().</P><P>&nbsp;</P><P>I tried do this using LOOKUPVALUE but I didn't succeed</P> Fri, 21 Jan 2022 14:27:30 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/LOOKUPVALUE-with-multiple-matches/m-p/2295797#M56583 gorikovsk21 2022-01-21T14:27:30Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/LOOKUPVALUE-with-multiple-matches/m-p/2295832#M56585 <P>Hi,<BR /><BR />I need some further information to tackle this. What is your end goal with the data? It is possible to return e.g. latest, second latest and third latest dates into a column, but I wouldn't necessarily recommend this. Also do you want fill all the 1, 2, 3 columns or just [3 date]?<BR /><BR /></P> Fri, 21 Jan 2022 14:41:52 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/LOOKUPVALUE-with-multiple-matches/m-p/2295832#M56585 ValtteriN 2022-01-21T14:41:52Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/LOOKUPVALUE-with-multiple-matches/m-p/2295866#M56588 <P>I would like to do like this picture:</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="WhatsApp Image 2022-01-21 at 11.59.25.jpeg" style="width: 327px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/659242i3EA35FEC09AEA1BF/image-size/large?v=v2&amp;px=999" role="button" title="WhatsApp Image 2022-01-21 at 11.59.25.jpeg" alt="WhatsApp Image 2022-01-21 at 11.59.25.jpeg" /></span></P><P>&nbsp;</P><P>I need to know sale date of each product, but grouped by collumns for each sale date : 1° sale date,&nbsp;2°&nbsp;sale date and 3°&nbsp;sale date.</P><P>&nbsp;</P><P>Thank you for your reply!</P> Fri, 21 Jan 2022 15:04:23 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/LOOKUPVALUE-with-multiple-matches/m-p/2295866#M56588 gorikovsk21 2022-01-21T15:04:23Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/LOOKUPVALUE-with-multiple-matches/m-p/2295886#M56590 <P>I would like to do like this picture:</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="WhatsApp Image 2022-01-21 at 11.59.25.jpeg" style="width: 327px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/659247i4F5E0376C041914B/image-size/large?v=v2&amp;px=999" role="button" title="WhatsApp Image 2022-01-21 at 11.59.25.jpeg" alt="WhatsApp Image 2022-01-21 at 11.59.25.jpeg" /></span></P><P>&nbsp;</P><P>I need to know sale date of each product, but grouped by collumns for each sale date : 1° sale date,&nbsp;2°&nbsp;sale date and 3°&nbsp;sale date.</P><P>&nbsp;</P><P>Thank you for your reply!</P> Fri, 21 Jan 2022 15:13:18 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/LOOKUPVALUE-with-multiple-matches/m-p/2295886#M56590 gorikovsk21 2022-01-21T15:13:18Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/LOOKUPVALUE-with-multiple-matches/m-p/2300526#M56811 <P>Hi&nbsp;<a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/353339">@gorikovsk21</a>&nbsp;,</P> <P><SPAN>Please refer to the following steps to see if it helps you.</SPAN></P> <P><SPAN>Create a column.</SPAN></P> <LI-CODE lang="markup">RANK = VAR rank_ = RANKX ( FILTER ( Sales_2, Sales_2[ID_Product] = EARLIER ( Sales_2[ID_Product] ) ), Sales_2[sales_date], , ASC, DENSE ) RETURN rank_ &amp; " Sales_Date"</LI-CODE> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="vpollymsft_0-1643100847443.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/660465iBEB3D64EC22035BB/image-size/medium?v=v2&amp;px=400" role="button" title="vpollymsft_0-1643100847443.png" alt="vpollymsft_0-1643100847443.png" /></span></P> <P><SPAN>Best Regards</SPAN></P> <P><SPAN>Community Support Team _ Polly</SPAN></P> <P><SPAN>&nbsp;</SPAN></P> <P><SPAN>If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.</SPAN></P> <P>&nbsp;</P> Tue, 25 Jan 2022 08:55:02 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/LOOKUPVALUE-with-multiple-matches/m-p/2300526#M56811 Anonymous 2022-01-25T08:55:02Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/LOOKUPVALUE-with-multiple-matches/m-p/2578064#M73883 <P>Hey buddy, how about if I wanted the second value for instance?<BR />Is there any way to return the Nst value?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sem título.png" style="width: 188px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/732145iF19BEA66BE2E012B/image-size/large?v=v2&amp;px=999" role="button" title="Sem título.png" alt="Sem título.png" /></span></P> Tue, 14 Jun 2022 15:28:47 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/LOOKUPVALUE-with-multiple-matches/m-p/2578064#M73883 Anonymous 2022-06-14T15:28:47Z