Get data from table

HI Omelei ,

You can create a column as below:-

Column =
LOOKUPVALUE (
    Opportunity[prev opp id],
    Opportunity[Opp id], OpportunityConfig[opportunity id]
)

Hi Omelei ,

Please try to create a new column with below dax formula:

Column =
VAR cur_oid = [Opportunity ID]
VAR o_id =
    CALCULATE (
        MAX ( Opportunity[Previous Opportunity ID] ),
        Opportunity[Opportunity ID] = cur_oid
    )
VAR cur_pid = [Product ID]
VAR _val =
    CALCULATE (
        MAX ( Productconfig[Quantity] ),
        FILTER (
            ALL ( Productconfig ),
            [Product ID] = cur_pid
                && [Opportunity ID] = o_id
        )
    )
RETURN
    _val

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.