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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.