Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello guys,
How to merge two column (add hyphen symbol only in between), but in Direct Query mode ?
Thanks
Solved! Go to 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 , 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
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,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |