Forum Discussion
Lookup help
jbrines Hi! Can you share the pbix file with tables? or paste data so that i can copy them directly?
Thx
BBF
💡 Did I answer your question? Mark my post as a solution!
👍 Kudos are appreciated
🔥 Proud to be a Super User!
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
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.
jbrines Hi!
Here the calculated column:FINAL AGGREGATED =VAR SLA_DAYS =LOOKUPVALUE('SLA Time'[Sum of Time (days)],'SLA Time'[Category],'Results Data'[Category])VAR DELTA ='Results Data'[Actual Time] - SLA_DAYSRETURNIF(DELTA > 0, "YES", "NO")
I attack also the pbix file! 🙂
Let me know
BBF
💡 Did I answer your question? Mark my post as a solution!
👍 Kudos are appreciated
🔥 Proud to be a Super User!
Hi BeaBF it works but not showing the correct results. Is it because the Actual Time in Results Data is a Messure?
How do you upload PBIX files to a message, so I can you show you.
