Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
vitexo87
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
jdbuchanan71
Super User
Super User

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
v-lili6-msft
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.
jdbuchanan71
Super User
Super User

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors