Forum Discussion
Help concatenate fields
Hi everyone, someone could support me in telling me how I can concatenate two columns if I am using the Direct Query connection mode, and it does not let me use CONCATENATE, what would be the option?
I appreciate your support.
1 Reply
Plase look at the modeling limitations when we are in DQ
But try this calculation:
New Column = 'Table'[Column1] & " | " & 'Table'[Column2]Best regards
Bruno Costa | Power Participant
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
You can also check out BI4ALL's website and our data solutions!
