Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 Laagste Prijs" from the table Verpakking in the product table.
There is a relationship between the two tables (based on the product_id).
So I don't realy understand why I can't find the the tables using the related function.
I've added a link to the pbix file.
Can someone help me?
Kind regards,
Solved! Go to Solution.
Hi @SL_1983 ,
You can create a column in "Product" Table as follows:
If this helps appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
Hi @SL_1983 ,
You can create a column in "Product" Table as follows:
If this helps appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
Hello,
that indeed does the trick.
Now I want to calculate the cost of the recipe using the lowest price value. I also want to calculate the price based on the package (because even though I don't need the whole package to make the recipe, i still need to buy it).
I've tried it using summarize, but that doesn't work.
The link to the file:
@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])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
83 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |