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 All I have 2 data sets that i want to combine as one. The first is a call data base where i have start and end time of the call The second is the time a ticket was submitted I want to capture the ticket number of each call
**Example Calls Data** Call Start Call End Username
**Example Tickets Data** Ticket Number Submited Username
The Third issue is the usernames don't match but i have many solutions for that. **Ideal Result** Call Start Call End Username Ticket Number
I can do this with Excel macro's or SQL, then load the dataset but i'd love to be able to do it directly through Power BI. Any help would be appreciated Thanks
Hi @chadcook3,
You can split the column "Username" of "Example Tickets Data" in the Query Editor with the built-in function. Then it's easy to get "Ticket Number". The concern could be the duplicate usernames. Are there any other conditions we can apply?
Best Regards,
Dale
Hi,
If the Name can be made the same between both datasets, then we can solve this problem using DAX.
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
146 | |
110 | |
107 | |
86 | |
63 |