Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

error in union dax function result

I have a table that contains data extracted from a sql database, I duplicated it by changing your query to just the date of the data I need, for example in table 1 I have data from October and in tab...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    6 years ago

    You can use the SELECTCOLUMNS in your UNION to define the order.

     

    NewTable =
UNION (
SELECTCOLUMNS ( Table1, "Field1",Table1[Field1],"Field2",Table1[Field2]),
SELECTCOLUMNS ( Table2, "Field1",Table2[Field1],"Field2",Table2[Field2])
)
v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

hi Anonymous 

If the two tables have the same column order? please keep them with same column order.

and you still have the problem, please share a simple sample pbix file.

 

Regards,

Lin