Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I request your guidance and help to solve this issue of mine related to a call centre dashboard
employees log in at 07:00 pm on 01st July 2022 and they log out at 03:00 am on 02nd July 2022. How can i calculate the hours worked considering it as a single day ( i.e 8 hours duty )
regards,
dsmitha
Solved! Go to Solution.
Hi @dsmitha ,
Do you want to calculate the time interval between dates?
Try the DATEDIFF function:
DATEDIFF(<Date1>, <Date2>, <Interval>)
DATEDIFF function (DAX) - DAX | Microsoft Docs
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @dsmitha ,
Do you want to calculate the time interval between dates?
Try the DATEDIFF function:
DATEDIFF(<Date1>, <Date2>, <Interval>)
DATEDIFF function (DAX) - DAX | Microsoft Docs
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
79 | |
61 | |
60 | |
58 |
User | Count |
---|---|
151 | |
113 | |
99 | |
80 | |
72 |