After Union Two tables, data goes to the wrong column with Power BI DAX? 

Power BI really a junk! I have 94 columns.

Thank you ,Dhruvin This helped me

This is only good if you have really low table counts to union

Thank you, it is very useful.

Thank you bro, you saved me!

As there are only four columns and two tables, it looks easy to perform union in this way. If we have more than 20 columns(unordered in two or more tables), it will get real tough to make calculation like this. Is there any other simple way?

Thanks

Unfortunatelly it works in Analysis Services, but when I create table in PowerBI I have mixed columns again. Any idea why?

Thanks! This really helped me with columns that wouldn't line up in Union, even though I kept re-ordering them in the Transform view.

Thanks for providing the workaround with UNION(SELECTCOLUMNS(),SELECTCOLUMNS()). I need to union two tables plus a third one which did not have all the columns of the first two. So I added "dummy" empty columns with two quotes or BLANK() for values. It worked!

Thank you for taking the time to make and to share. A really helpful video that solved the column ordering issue I was having with the Union function.

Very clear and good explanation to solve a specific problem.

This is perfect. This is pretty much the only solution to get around the column order issue with union function and it worked!

Great! Thx

Can i use append query instead of union after arranging columns same in both table??