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 am trying to create a new table using UNION based on an exisiting table called 'PharmaAuditGW" as follows:
Original table called PharmaAuditGW
The column headers are exchanged together with the values of the newly created row.
Hi @Chitemerere
try to use the same column names and order, like
PharmaAuditGW with Others = UNION(
ROW("ProductCode", 99, "Item", "Others"),
ALLNOBLANKROW('PharmaAuditGW'[ProductCode], 'PharmaAuditGW'[Item])
)
Thank you very much for your input, the solution did not work, see below:
Best regards,
Chris
Thank you very much for your response, most appreciated. The results are as follows:
The problem still exists.
Regards,
Chris
Try it once like this and see if it works
PharmaAuditGW with others - UNION(
ROW("ProductCode_wOthers", 99, "Item_wOthers", "Other"),
summary('PharmaAuditGW','PharmaAuditGW'[ProductCode], 'PharmaAuditGW'[Item])
)
you can filter from white in summary
Many thanks, that worked.
Regards,
Chris
@Chitemerere did you try putting the 99 in quotes? "99"? Maybe try switching the order of the second table? That's kind of interesting behavior!
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
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 |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |