excel Text Join method with Dax

[Anonymous]

Hi All,

Need to get the same Lookup Value column result.. Can someone help me..?

Country	Sales Rep		Country	Lookup Value
Brazil	Jena		Brazil	Jena, Marie
Brazil	Marie		Canada	Jack, Marie
Canada	Jack
Canada	Marie

Regards,

Murali

[PattemManohar · Accepted solution]

@Anonymous Please try this as a "New Table"

Test143 = SUMMARIZE(_Emp,_Emp[Deptno],"Names",CONCATENATEX(_Emp,_Emp[Ename],","))

[v-jiascu-msft · Accepted solution]

Hi Murali,

A measure solution in a Table visual.

Measure 2 =
CONCATENATEX ( VALUES ( Table2[Sales Rep] ), [Sales Rep], "," )

Best Regards,
Dale

[PattemManohar · Accepted solution]

@Anonymous Please try this as a "New Table"

Test143 = SUMMARIZE(_Emp,_Emp[Deptno],"Names",CONCATENATEX(_Emp,_Emp[Ename],","))