Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm trying to visualize the Bill of Materials dataset in power BI. However, when I use the PATH function to flatten the BOM Parent-Child Hierarchy, it comes up with the error as follows.
Any solutions for me? I have tried to solve by following some below links but have no luck.
http://www.daxpatterns.com/parent-child-hierarchies/
Bill of Materials (BOM) solution in Excel and PowerBI – The BIccountant
Solved: Parents - Child Hierarchy for Bill of Materials - Microsoft Power BI Community
Thanks a lot for your time and assistance.
I have tried to fix the issue using the DAX. First I detect the missing assemblies as follows:
Then, I create the Hierachical assemblies table that includes all the missing values of 'parentItemN'o in the the 'no' column:
However, It come up with another issue as captured below:
Does my DAX code is correct? I see the topic below is the same but has not resolved yet.
All it's saying is that you need to add the values in the parentid column into the 'no' column (even if they just point at themselves).
That will make the error go away.
Thanks for your suggestion. I did try that and it works for this specific item. But I do not want to change the data structure as it has thousands of records. Any other solutions?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
95 | |
82 | |
71 | |
64 |
User | Count |
---|---|
115 | |
105 | |
95 | |
79 | |
72 |