Solved: union formula column section error

andywil456 · ‎10-19-2016

I have 3 sharepoint files all with a number of excel tables. All the tables are in the same format and layout, for each field sale to complete. the 3 sharepoint files cover different periods but the format and layout is consistant throughout.

I have used the Union formula to create 1 master database to build my dashboard from, however the union formula has mixed up the columns. As per my screenshot in the date column i have a few dates but also a few postcodes etc.

Is there anyway of redirecting each column so that the correct data is being selected?

v-sihou-msft · ‎10-24-2016

@andywil456

In DAX, when using UNION(), columns are combined by position in their respective tables. And column names in the return table will just match the column names in table_expression1. So make sure columns in two tables has same order. In your scenario, I suggest you go to Query Editor, "move" columns under Transform tab.

Then you can use "Append Query" to combine two datasets together.

Regards,

View solution in original post

v-sihou-msft · ‎10-24-2016

@andywil456

In DAX, when using UNION(), columns are combined by position in their respective tables. And column names in the return table will just match the column names in table_expression1. So make sure columns in two tables has same order. In your scenario, I suggest you go to Query Editor, "move" columns under Transform tab.

Then you can use "Append Query" to combine two datasets together.

Regards,