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])
)
jdbuchanan71's avatar
jdbuchanan71
Super 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])
)