Forum Discussion

gorikovsk21's avatar
gorikovsk21
Frequent Visitor
4 years ago
Solved

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 ...
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

     

ValtteriN's avatar
ValtteriN
Icon for Community Champion rankCommunity Champion
4 years ago

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's avatar
gorikovsk21
Frequent Visitor
4 years ago

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!