Greeting all ,
i need a trick so i can implement role access via power bi
i have 2 tables Offer and 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 !
Go to Solution.
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.
View solution in original post
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.
Check out a full recap of the month!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.