Simple merge two columns in Direct Query

[admin_xlsior]

Hello guys,

How to merge two column (add hyphen symbol only in between), but in Direct Query mode ?

Thanks

[amitchandak · Accepted solution]

@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

[admin_xlsior]

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,

[amitchandak]

@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

[admin_xlsior]

Hi @amitchandak 

In DAX by means the "CombineValues", right ? Yes, as mentioned, it works.

I just want to confirm about the limit, that's all. Sorry to confuse you.

Anyway thanks,