Left outer join using dax with 2 tables - Direct Data

[TrangHoThu]

I have a similar issue for which I'm looking for a solution. It's actually a merge query but as I'm not allowed to use the 'merge' functionality from power query (scheduled refresh on power bi server does not support that) I have to use DAX syntax to mimic this.

Here is the situation:

- merge Table A, Table B and Table C into new Result

- I need all records from Table A

- Add matching records from Table B as new columns where tableA.id= tableB.id

Hope the picture below makes it more clear 

thanks in advance!

Lily.

[ERD · Accepted solution]

Hello @TrangHoThu ,

Here is an article that will help you to achieve the result in various ways: Lookup multiple values in DAX - SQLBI.