When I run the SELECTCOLUMNS command, Power BI shows me a column with the word [List]

[Syndicate_Admin]

Hello tod@s. I'm trying to join 2 tables using the UNION command, but since the tables are a bit different, I have to use the SELECTCOLUMNS command first. Below I show only two fields (the table has like 20)
Of the 2 source tables, one has the RMA active, and the other has the RMA closed.
The problem is that when you create the table, it does not mark errorers, however, instead of showing the RMA Numbers (Return of Authorized Matter), it shows me the word [List] (so, with braquets)

As these are the detail tables, there can be more than one line with the same RMA number.

Combined RMA Details =
UNION(
SELECTCOLUMNS('RMA Details List' ,
"ID", 'RMA Details List' [ID]
,"RMA Number", 'RMA Details List' [RMA Number]
)
,
SELECTCOLUMNS('RMA Closed Details List' ,
"ID", 'RMA Closed Details List' [ID]
,"RMA Number", 'RMA Closed Details List' [RMA Number]
))

result:

But I need in RMA Number, not the word [List]

[PC2790 · Accepted solution]

Hello @Syndicate_Admin ,

Have you tried using Append function in Power Query instead of using a DAX?

Also, if you can share your sample data to try and replicate your issue.

I have tried thic combination of UNION and SELECTCOLUMNS at my end and it is returning result in the expected format.

Thanks

[Syndicate_Admin]

A thousand apologies, the word [List] comes from the Sharepoint List, the original source of the information. I hadn't noticed it.

[Syndicate_Admin]

If I tried using Append, but since the column names are not exactly the same (design errors) and one table has extra columns that the other does not, and finally there are columns with the same name, but with different data, therefore append does not work,