Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

excel Text Join method with Dax

Hi All,

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

 

CountrySales Rep CountryLookup Value
BrazilJena Brazil Jena, Marie
BrazilMarie Canada Jack, Marie
CanadaJack
 
  
CanadaMarie   

 

Regards,

 

Murali

Need Help
  • PattemManohar's avatar
    PattemManohar
    7 years ago

    Anonymous Please try this as a "New Table"

     

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

  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Murali,

     

    A measure solution in a Table visual.

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

    excel-Text-Join-method-with-Dax

     

    Best Regards,
    Dale

2 Replies

  • PattemManohar's avatar
    PattemManohar
    Community Champion
    7 years ago

    Anonymous Please try this as a "New Table"

     

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

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    7 years ago

    Hi Murali,

     

    A measure solution in a Table visual.

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

    excel-Text-Join-method-with-Dax

     

    Best Regards,
    Dale