Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 !
Solved! Go to 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
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.
User | Count |
---|---|
118 | |
66 | |
65 | |
56 | |
50 |
User | Count |
---|---|
182 | |
85 | |
67 | |
61 | |
53 |