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.
Dear all, good morning.
I am trying to check if a value in one column appear in another one. The issue I am currently facing is that the column may contain multiple values and I would need to check these one by one.
Below is the situation I am facing:
I have a table with all customer requests:
Customer | Requested Service | Status |
A | Pick-up | *This column should be completed based on the other column |
B | Pick-up | *This column should be completed based on the other column |
C | Delivery | *This column should be completed based on the other column |
And another one with the services completed for each customer
ServiceNum | ServiceType | Realised for |
1 | Pick-up | A,B |
2 | Delivery | C |
Desired Result:
Customer | Requested Service | Status |
A | Pick-up | Completed |
B | Pick-up | Completed |
C | Delivery | Completed |
How may I achieve this ?
Hello @davehus , good morning.
No, I understood what you did but lets say I have a column with 10 different Customers for the realized column. I would split by delimiter "," and afterwards unpivot the selected columns right?
Lets say after 1 month I have the column with 20 customers, it will not pivot all of the 20 columns, since I selected only the previous 10 correct?
Hi @Anonymous , I've based the attached on your example. Please click through the powerquery steps to see how the data is being transformed. Is this what you need?
https://drive.google.com/file/d/1JfF072By-CHOUi3uzk-GMA8nVdNrKeXY/view?usp=sharing
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 | |
95 | |
77 | |
69 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |