Forum Discussion
I need to see different prices for different orders based same material separately
Hello ,
I have 2 files. First excel is for orders, materials, prices of materials. for each order material price can be different. other file has available stock.
my problem is, when I try to see total stock availability price for each order. Power BI calculates based on total stock availability, but I need to see price only for that order. I am sharing a snapshot what I mean. on the right side you can see seperate stock availability for same material.
If I do not summarize stock availability I see same lines for each stock
Thank you in advance
Baris
11 Replies
- Kedar_Pande
Super User
To fix this, make sure you're using relationships correctly between the two files. You need to link the order to its specific material and price in the orders table. Then, create a measure for calculating the stock price for each order rather than summarizing total stock.
Use SUMX or a similar function to calculate the price for each row based on the order material and quantity, so Power BI doesn’t summarize stock across all orders.
- Kedar_Pande
Anonymous Share the file - [email protected]
I can not use onedrive due to restrictions in my pc from company rules.
May you give me your e-mail from DM ? I can share dthe sample data for you
Thank you in advance
Baris
