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.
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.
This is the output that used the DAX I proviced
If this is not correct. Then what's the expected output? Please also provide the corresponding logics
For Main number 5663, I would like below output:
The Assemply row should be deleted as I have all the details in the blue rows instead. And the blue rows should have Main number 5663 instead of 5664. Does it make any sense?
the first one row does not display.
in the visual filter, unselect assembly.
for the 2nd question. why replace last 6 rows to 5664. The rest rows may have the same name ,sub num ,etc. What's the logic to pick out these 6 rows? could you pls clarify?