Forum Discussion
Dax Join
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 i...
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
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.