Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi all.
I have a problem, how to calculate check in and check out times that are done multiple times in one day?
I just need an early checkin and late checkout time of the day.
So it applies if he checks in before 08:00 AM, then he is on time, and if he checks out after 05:00 PM, then he is on time too every user
Solved! Go to Solution.
Hi @PowerVisualBI ,
Try the below dax to create a new table,
CALCULATETABLE (
SUMMARIZE (
TableName,
'TableName'[Tgl]
"In",Min('TableName'[In]),
"Out",Max('TableName'[Out]),
)
)
And use the below dax as a calculated column
If(and([in]<=Time(08,00,00),out>=time(17,00,00)),"On Time", "Not On time")
If there is any issue please copy and paste a sample table from excel. And mention the issue so that I can Create a file that I can share with you.
Thanks and regards,
Atma.
Hi @PowerVisualBI ,
Try the below dax to create a new table,
CALCULATETABLE (
SUMMARIZE (
TableName,
'TableName'[Tgl]
"In",Min('TableName'[In]),
"Out",Max('TableName'[Out]),
)
)
And use the below dax as a calculated column
If(and([in]<=Time(08,00,00),out>=time(17,00,00)),"On Time", "Not On time")
If there is any issue please copy and paste a sample table from excel. And mention the issue so that I can Create a file that I can share with you.
Thanks and regards,
Atma.
Hello @Dhacd
What about the user? because if I use the DAX formula above, I can only see the earliest check-in and the last checkout. I want to see it by user. Because users can check in and check out many times a day. But I just want to count this check, he's the earliest and his checkout is the last
Hi @Dhacd
I've tried the DAX you provided, but I haven't found a solution yet. You can check my file below
https://drive.google.com/drive/folders/1plQwa5E0C2k7n21-cZUO2EoUnONRMXpd?usp=sharing
User | Count |
---|---|
77 | |
74 | |
42 | |
32 | |
28 |
User | Count |
---|---|
100 | |
93 | |
52 | |
50 | |
48 |