Merge multiple tables using DAX

Hi


I'm looking for a solution to below mentioned query. 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 yet) I have to use DAX syntax to mimic this.



Here is the situation:


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

- I need all records from Table A

- Add matching records from Table B as new columns where tableA.version= tableB.version and tableA.version2=tableB.version2

- if there is no matching record from Table B:

first match Table C where tableA.version= tableC.version and tableA.version2=tableC.version2
match Table B where tableB.version= tableC.version3 and tableA.version2=tableC.version4


Hope the picture below makes it more clear...



thanks in advance!

Muki