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.
I have 2 tables. A table with lead details and a table with contact info both have a LeadID column.
Some leads have several phone numbers and I just wanted to know how I can create a table with all the Lead IDs and the various phone numbers we have for them in seperate columns.
Thanks in Advance for any help
Hi @dexterwoolfe,
You can separate them using Split Column in the Query Editor.
Best Regards!
Dale
Unfortunatley this wouldn't work in this instance as the various phone numbers aren't in the same cell. They are in a seperate table on different rows under the same 'LeadID.' Hopefully the below screenshot will clarify.
Hi @dexterwoolfe,
Could you please provide a dummy pbix file?
Best Regards!
Dale
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 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |