Forum Discussion
UNION function mixes columns
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
Hi,
I have the same issue, can you please explain how you solved it?
Can you supply the syntax for this? Thnk you Fia123
