Dax Join

[Anonymous]

Greeting all ,  

i need a trick so i can implement role access via power bi 

i have 2 tables Offer and application 

Offer : 

Application : 

i want to add a column in the offer table where i can have the list of name per offer !

the results that i want is the following : 

 

Can i do that with Dax or power Query please ? 

Thanks in advance to everyone ! 

[v-gizhi-msft · Accepted solution]

Hi,

Please try to create a calculated column:

Column = CONCATENATEX(RELATEDTABLE('Application'),[Candidate name],",")

Or you can create a measure:

Measure = CONCATENATEX('Application',[Candidate name],",")

And both of them show what you want:

Hope this helps.

Best Regards,

Giotto Zhi

[Tad17]

Hey @Anonymous 

This is what you are looking for: https://community.powerbi.com/t5/Desktop/Concatenate-rows-values/td-p/41936

Yours would be something close to CANDIDATE NAME = CONCATENATEX('Apllication',[Candidate name]," , ")

If this helps please kudo.

If it answers your question please also accept it as a solution.