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.
Hi,
I'm trying to restore my memories about dbs back into place.
I got two simple tables and I want them to be "connected"
TABLE 1
user 1; group 1
user 1; group 2
user 2; group 2
user 2; group 3
TABLE 2
group 1; link 1
group 1; link 2
group 1; link 3
group 2; link 1
group 2; link 3
group 2; link 4
group 3; link 5
The result should be this
RESULT TABLE
user 1; group 1; link 1
user 1; group 1; link 2
user 1; group 1; link 3
user 1; group 2; link 1
user 1; group 2; link 3
user 1; group 2; link 4
user 2; group 2; link 1
user 2; group 2; link 3
user 2; group 2; link 4
user 2; group 3; link 5
What is the fastest way to obtain this in powerquery without DAX ?
Or, is there a "complete" DAX composer ?
Solved! Go to Solution.
You may be able to do that join in Power Query but you could also create a bridge table to do it I believe. And then it is just tabular relationships.
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 |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |