Forum Discussion
Create new table
Hi helen_wrensted1,
We are following up to inquire whether your issue has been resolved. If it has been resolved, we would be grateful if you could share the solution with the community, as it may help others facing similar challenges.
However, if the issue remains unresolved and you have any further queries related to it, please share either a simplified or a sanitized PBIX file. Alternatively, you may provide the data model diagram from the Relationships view, along with a small sample dataset containing 2 to 3 rows for all tables.
Please ensure the data is relevant and clearly demonstrates your issue or query in a structured format (not as an image), and that it is free from any sensitive information. Also, please include the expected outcome based on the provided data.
Thank you.
Hi ryan_mayu
Thanks a lot for your suggestion.
Unfortunately, the column doensn't work as Main number 5664 is included in multiple other main numbers and not only 5663. It will probably be necessary to create a new table, where there will be more rows than the original, as the assembly rows will be replaced by the Sub number rows. In this case one row will be replaced with the 3 rows for main number 5664.
then pls update the sample data and expected output. I think you need to consider all the possible scenarios in your sample data. Otherwise, the solution we provided can solve your current issue, but can't can apply to your real data.
I can only see one table in your pbix file, the second table you mean is table visual?
maybe you can create an expected column at then end
Sorry, I wasn't very clear. I was referring to the tables in Report view - there is only one data table.