Forum Discussion
Fia123
Helper II
Helper IIUNION 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 :-)
vanessafvg
Community Champion
Community Championcan you use selectcolumns dax function to list the order it should go in?
Fia123Do you mean, first making two new tables by use of Selectcolumns - and afterwards combined those two with use of UNION?
- Fia123
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 :-)
- vanessafvg
great