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.

     

Anonymous's avatar
Anonymous
Not applicable
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.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

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