User Profile
RanHo
Helper V
Joined 5 years ago
User Widgets
Contributions
ALTERNATIVE DATE TIME site for powerbi report
Good day ! Do you have suggestion site for realtime datetime to use for powerbi report? this is the one I used for my report its not working anymore until today. Note: free api if there is. https://www.timeapi.io/api/time/ http://worldtimeapi.org/api/timezone Hope you help guys. Thanks in advance! ~RanSolved1.3KViews1like2CommentsGet number count of column that are not in other column/table
Good day! Need help here , how to get count of EVALUATION ID that are not in TABLE TEST? Here's my sample data with 3 tables: TABLE EVALUATION TABLE EMPLOYEE TABLE TEST ID EMPLOYEE_ID ID EMPLOYEE_NO ID EMPLOYEE_NO 1001 1 1 TC-001 2001 TC-002 1002 3 2 TC-002 2002 TC-004 1003 6 3 TC-003 2003 TC-005 1004 7 4 TC-004 2004 TC-008 1005 10 5 TC-005 2005 TC-009 1006 6 TC-006 2006 1007 7 TC-007 2007 1008 8 TC-008 2008 1009 9 TC-009 2009 1010 10 TC-010 2010 thanks in advance! ~RANSolved1KViews0likes7CommentsHow to compare 2 columns in different table and get if they have same data
Good day! Can someone help , I have 3 table here exam table, employee table and status table: my objective is get the exam with the status of 1 & 3 only, after that get the employee code that has exam status 1 & 3 and then check if that employee is passed or failed. RESULT i want is to put the count in card visual / list of it in table visual sample table EXAM TABLE employee id id status 1 3001 1 2 3002 2 3 3003 3 7 3004 3 8 3005 2 9 3006 1 10 3007 3 13 3008 1 14 3009 1 15 3010 2 EMPLOYEE TABLE ID NAME employee code 1 employee1 GC001 2 employee2 GC002 3 employee3 GC003 4 employee4 GC004 5 employee5 GC005 6 employee6 GC006 7 employee7 GC007 8 employee8 GC008 9 employee9 GC009 10 employee10 GC010 11 employee11 GC011 12 employee12 GC012 13 employee13 GC013 14 employee14 GC014 15 employee15 GC015 STATUS TABLE id status code employee code s1 passed GC001 s2 failed GC002 s3 passed GC003 s4 passed GC007 s5 failed GC008 s6 failed GC009 s7 passed GC010 s8 passed GC013 s9 failed GC014 s10 passed GC015 ~RANSolved521Views0likes2Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.