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 |
Hi,
Based on the 2 tables that you have shared, show the expected result.
Hi Ashish_Mathur ,
Basically in the mesure column I want it to look at the Category in the results data table, compare it to the Category on Table SLATime Data then use the Sum of Time field to subtract from the Actual Time on the results data table if it is zero or poistive then the outcome should be Yes, if it is a negative the outcome should be No. The Actual Time Column the Results Table in Power Bi is currently a messure column
I hope that makes sense.
Sorry but cannot understand your response.