Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 : 

 

 

 

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 ! 

Need Help
Tips and Tricks
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    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

2 Replies

  • v-gizhi-msft's avatar
    v-gizhi-msft
    Community Support
    6 years ago

    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