Forum Discussion
Helper IIIPower BI model for Production Process
Super UserPlease provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Helper IIIThanks for your Help
the model represent 2 Srore, these stores manufacture some products and we want to monitor the performance of these stores, there are 3 tables
Table 1 Material Represent the quantity of Materials in each product (there are some common materials)
Table 2 Sales , represent the sales of the product and the cateogry of each product and also the unit price per each KG from the product and the quantity in each product (actually the product is a soap Bottle and finally the store in whcih this bottle is saled.
Table 3 Material Price Represent the material Price in each Month.
What I want to create relationships between these tables and create measure to calculate
1-the cost Per Bottle(Product) (Quantity of Material From Table Material and Material Price From Material Price Material (Price are changing over Time)
2-Total Bottles Saled each Month
3-Total Material Used over Month
4-Total Revenue (Number of Bottles*Quantity in Bottle*Unit Price)
5-Profit Per Bottle and Total Profit per each Product (Bottle)