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've got one table with groups and low-level teams:
Group1 | Group2 | Group3 | Group4 |
A | D | I | M |
B | E | J | N |
C | F | K | |
G | L | ||
H |
In a different table I've got tickets and and one of team {A, B, ..., N} assigned to it.
ID | Team | Group |
1 | A | |
2 | I | |
3 | N | |
4 | B |
What I need to do is fullfil Group column based on first table assigmnet. How to do this?
BR
Rafal
Solved! Go to Solution.
Hi @rmieszko
I advise you to open your Query Editor then to unpivot all the columns of your table 1.
You will also get that:
You also will able to use the function Merge Queries to get the data you need in your other table.
Regards,
CR
for the merge queries, here are the steps:
Then you select only Attribute
Regards,
CR
Hi @rmieszko
I advise you to open your Query Editor then to unpivot all the columns of your table 1.
You will also get that:
You also will able to use the function Merge Queries to get the data you need in your other table.
Regards,
CR
for the merge queries, here are the steps:
Then you select only Attribute
Regards,
CR
I guess it's good idea 🙂 I will check this on Monday and let you know. Thank you!
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |