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

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