Forum Discussion
Solved
Lookup help
Hi guys, I am converting an excel spreadsheet (below) in to Power BI. I have a Table names SLATime which is a list categories with an SLA Time for each category. I want to create ...
Hi BeaBF
Results data
| Ticket | Subject | Created Date | Closed Date | created_by | Owner | Category | Sub-Category | Actual Time |
| IT-22865 | Force Check In | 02/11/2025 17:34 | 03/11/2025 07:35 | Shannon Kelly | Jonathon Hewitt | PIM | Force Check In | 0 |
| IT-22866 | Suspicious Email Reported by | 03/11/2025 07:22 | 03/11/2025 08:49 | Ian Stewart | Scott Young | Suspicious Email | Genuine | 0 |
| IT-22867 | PIM NOT WORKING | 03/11/2025 07:38 | 03/11/2025 09:12 | Macauley Wilson | Jonathon Hewitt | PIM | Local File Management | 0.025 |
| IT-22868 | Suspicious Email Reported by | 03/11/2025 07:57 | 03/11/2025 09:07 | Barry McAulay | Scott Young | Suspicious Email | Phishing Test | 0.014583333 |
| IT-22869 | Access to site sign in | 03/11/2025 08:21 | 03/11/2025 08:33 | Georgie Chisholm | John Brines | Software | Microsoft Teams | 0 |
SLATime Data
| Category | Sum of Time (days) |
| Account Lockout | 0.042 |
| BT Cloud Phone | 0.5 |
| Business Central | 3 |
| Cisco Duo | 0.042 |
| Conquest | 1 |
| Desk Move | 2 |
| Dime | 3 |
| Door Cards | 1 |
| 0.5 | |
| Email Photo Update | 2 |
| Folder Access | 1 |
| FortiClient | 0.5 |
| GDPR Delete | 1 |
| Hardware - Office | 1 |
| Hardware - Site | 3 |
| Internet | 1 |
| Jet | 1 |
| Laptop Build | 5 |
| Mailbox Access | 1 |
| Mobile Phone - Office | 2 |
| Mobile Phone - Site | 3 |
| Net 2 Access Control | 0.5 |
| New Email Address | 1 |
| Password Reset | 0.042 |
| PIM | 1 |
| Printer | 1 |
| Software | 1 |
| Spam Issue | 0.084 |
| Suspicious Email | 0.084 |
| User Account Change | 1 |
how to turn SLATime Data into result data? could you pls elaborate more on this ?
pls provide the sample data and the expected output based on the sample data you provided