Forum Discussion
Solved
UNION function mixes columns
Hi, I know that this subject has been discussed earlier in this forum, but I still don't know how to solve my issue. I am making a PWBI model based on data from two different ERP systems. I have ...
I used Selectcolumns first and then the UNION function - and it worked great!!!!!!
This is a much more tidy way to do it - it provides a clear distinction between extrated and transformed data.
Thank you very much - a learn something new :-)
can you use selectcolumns dax function to list the order it should go in?
Do you mean, first making two new tables by use of Selectcolumns - and afterwards combined those two with use of UNION?
I used Selectcolumns first and then the UNION function - and it worked great!!!!!!
This is a much more tidy way to do it - it provides a clear distinction between extrated and transformed data.
Thank you very much - a learn something new :-)
great