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..?   Country Sales Rep   Country Lookup Value Brazil Jena   Brazil  Jena, Marie Brazil Marie   Can...
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

PattemManohar's avatar
PattemManohar
Icon for Community Champion rankCommunity Champion
7 years ago

Anonymous Please try this as a "New Table"

 

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