Forum Discussion
Simple merge two columns in Direct Query
Hello guys,
How to merge two column (add hyphen symbol only in between), but in Direct Query mode ?
Thanks
admin_xlsior , In the direct query few column operations, are allowed
New column = [Col1] & "-" [Col2]
in case you need it to join use combinevalues : https://www.youtube.com/watch?v=rzbtXQrq43Y
4 Replies
admin_xlsior , In the direct query few column operations, are allowed
New column = [Col1] & "-" [Col2]
in case you need it to join use combinevalues : https://www.youtube.com/watch?v=rzbtXQrq43Y
Hi amitchandak
Many thanks, it works, infront by using CombineValues.
So just to confirm, we cannot do this kind of merge in Power Query editor, isn't it ? Since I tried that "new column" and then Column1 & "-" & Column2. After click ok then it is asking me to change storage mode to "Import"
Thanks,
admin_xlsior , there is a limit to what you can do Power Query and DAX. Try a new column in DAX and see if it works. I am able to create in DAX
