cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

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

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Dax Join

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
Highlighted
Solution Sage
Solution Sage

Re: Dax Join

Hey @rfrikha 

 

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.

Highlighted
Community Support
Community Support

Re: Dax Join

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

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors