cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Post Prodigy
Post Prodigy

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?

1 ACCEPTED SOLUTION
Super User II
Super User II

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

View solution in original post

2 REPLIES 2
Community Support
Community Support

hi @vitexo87 

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super User II
Super User II

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

View solution in original post

Helpful resources

Announcements
secondImage

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

secondImage

Power BI Women

Join our monthly meetings and learning sessions.

secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors