Forum Discussion
Power query formula
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 w...
Please try this solution
I have used Power Query to merge the various tables and create an exploaded BOM sales table.
The advanages of this solution is that all the heavy processing is done up front once, rather than each time you run a query.
It is also simply to understand and check, where the DAX for a BOM will be more complicated.
Hapy New Year !