You’re offline. This is a read only version of the page.
2
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
Hi Admin
Thank you for the input.
Generally speaking I understood the logic (merge tables). Obviously the scenario present returns a "limit" number of rows, on a real world scenarios we are handling with millions of rows. On this scenarios of millions of rows this solution present will keep to be the best "practice"?
I´m thinking as example if the data model will not be slow.
Thank you
#1
mmbr1606
9
Super User 2025 Season 1
#2
stampcoin
7
#3
SD-13050734-0
6
Share
Report
All responses (
Answers (
