Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
So my idea is that as much as possible... do everything in Query Design time.
With that, I simply want to create a composite key but this time around based on another table, so instead of me doing:
- New Column
- LookupValue(PrimaryID(other table),ForeignKeyTableWideID(other table),TableWideID(this table))
I'd like to have an equivalent logic in query design mode
- Add New Custom Column
- some kind of join???
Dummy PBIX: https://drive.google.com/open?id=0Bw37apQUhEqhdmJ0dTBZbVBuS1E
Solved! Go to Solution.
Merge Queries is the Answer.... Im all good now... thanks for all those who read this entry.
Merge Queries is the Answer.... Im all good now... thanks for all those who read this entry.
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |