Forum Discussion

SL_1983's avatar
SL_1983
Icon for Helper II rankHelper II
6 years ago
Solved

Problem with related function

Good morning, I have a problem with the function related. I want to create two columns using the function related in the Product table. I want to have the colums "Laagste Prijs" and "Verpakking Id...
Need Help
  • Pragati11's avatar
    Pragati11
    6 years ago

    Hi SL_1983 ,

     

    You can create a column in "Product" Table as follows:

    Laagste Prijs = LOOKUPVALUE(Verpakking[Laagste Prijs], Verpakking[Product Id], 'Product'[Product_ID])
     
    Similarly you can do for the other required column.
     

    If this helps appreciate a Kudos and mark it as a Solution! 🙂

     

    Thanks,

    Pragati

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

SL_1983,I tried something like this as a new column in the product table and seems to work

Column = minx(filter(Verpakking,'Product'[Product_ID]=RELATED('Product'[Product_ID])),Verpakking[Verpakking Id])