Forum Discussion
LOOKUPVALUE with multiple matches
I have two tables in Power BI
1° Table: products and sales date
2° Table: products ocurrency transactions date
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().
I tried do this using LOOKUPVALUE but I didn't succeed
Hi gorikovsk21 ,
Please refer to the following steps to see if it helps you.
Create a column.
RANK = VAR rank_ = RANKX ( FILTER ( Sales_2, Sales_2[ID_Product] = EARLIER ( Sales_2[ID_Product] ) ), Sales_2[sales_date], , ASC, DENSE ) RETURN rank_ & " Sales_Date"Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
Hi,
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]?I would like to do like this picture:
I need to know sale date of each product, but grouped by collumns for each sale date : 1° sale date, 2° sale date and 3° sale date.
Thank you for your reply!
I would like to do like this picture:
I need to know sale date of each product, but grouped by collumns for each sale date : 1° sale date, 2° sale date and 3° sale date.
Thank you for your reply!
Hi gorikovsk21 ,
Please refer to the following steps to see if it helps you.
Create a column.
RANK = VAR rank_ = RANKX ( FILTER ( Sales_2, Sales_2[ID_Product] = EARLIER ( Sales_2[ID_Product] ) ), Sales_2[sales_date], , ASC, DENSE ) RETURN rank_ & " Sales_Date"Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
