Power Platform Community Forum Thread Details

Hello All,

Happy new year 🙂

I would like to get your support to perform something that seems easy (and must be) but I can not figure it out (or better was able in a simple way which a huge work around manual calculation for each month which I have in my data set).

So the goal is to compute the cost of several products where we have the for each product a BOM - Bill of Material, the components costs could change over the months and make it more complex (if the cost of the components did not change over the months, and since the table of the components would be with unique values the connection of the tables make it kind of simple to handle).

So this is the goal, a Dax formula that compute the price per of the product over the component and take in consideration the months.

To make it easy attach we can find the example with the data set (summary excel file with the data loaded on the data model).

Hope this text/explanation was understandable, if not please let me know.

Thank you in advance