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 Email 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.
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!
