Concatenate columns of same table when you are using Direct query mode

[Anonymous]

Hi people,

I am trying to Concatenate EmpolyeeID with EmployeeName column which reside in the same table. Given that there may be two or more employees with same name but diffrent employeeId.

eg: 

EmployeeName    EmployeeID 

Zoe                             1

Zoe                             6

I do have EmployeeSK field available. I am using Direct query mode so i cannot have a calculated column, it has to be DAX measure whis should look like :

CashierName-Code 

Zoe - 1

Zoe - 6

I have tried concatenate function but it gives me error saying "a table of multiple values was supplied"

Thanks in advance

[amitchandak]

@Anonymous , this one is allowed in Direct query. Purpose To create a Key column. But you can try and check

https://docs.microsoft.com/en-us/dax/combinevalues-function-dax

[Anonymous]

@amitchandakI am getting error while trying to use the Dax,"A Table of multiple values was supplied where a single VAlue was expected.

[amitchandak]

@Anonymous , you created it as a column or measure? This need to created as a column

[Anonymous]

@amitchandak Since i am using SSAS it does not allow me to create a column and it greys it out 

[Anonymous · Accepted solution]

Hi @Anonymous ,

You can't manage data model while using live connection.

You may check about this article.

https://community.powerbi.com/t5/Community-Blog/Power-BI-Live-connection-vs-Import-comparison-and-limitations/ba-p/84377 

Best Regard,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks Jay, that makes sense, I just wanted to confirm before coming to a conclusion.

[harshnathani]

Hi @Anonymous ,

You may want to try this to handle customers with same name.

https://www.sqlbi.com/articles/handling-customers-with-the-same-name-in-power-bi/

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)