Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
You may take a look at https://www.sqlbi.com/articles/lookup-multiple-values-in-dax/.
You may take a look at https://www.sqlbi.com/articles/lookup-multiple-values-in-dax/.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |