Left outer join using dax with 2 tables - Direct Data

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.