Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The 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.

Reply
Anonymous
Not applicable

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 : 

2.png

 

 

 

Application : 

Capture.PNG

 

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 : 

 O_FiltresSS.PNG

Can i do that with Dax or power Query please ? 

 

Thanks in advance to everyone ! 

1 ACCEPTED SOLUTION
v-gizhi-msft
Community Support
Community Support

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:

61.PNG

Hope this helps.

 

Best Regards,

Giotto Zhi

View solution in original post

2 REPLIES 2
v-gizhi-msft
Community Support
Community Support

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:

61.PNG

Hope this helps.

 

Best Regards,

Giotto Zhi

Tad17
Solution Sage
Solution Sage

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.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.