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 table 2 I have data from january to september the structure of the two tables are exactly the same, when I perform the union function (table 1; table2) the resulting table has error in the data, for example I have the customer column and its values ​​are being displayed in the product column and this error occurs and several others. fields, how can I solve this?

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])
)

2 Replies

  • jdbuchanan71's avatar
    jdbuchanan71
    Icon for Super User rankSuper User
    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
    Icon for Community Support rankCommunity 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