LOOKUPVALUE with multiple matches

[gorikovsk21]

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

[Anonymous · Accepted solution]

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.

[Anonymous]

Hey buddy, how about if I wanted the second value for instance?
Is there any way to return the Nst value?

[gorikovsk21]

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!

[ValtteriN]

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]?

[gorikovsk21]

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!