Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |