Forum Discussion
uhassan
2 years agoFrequent Visitor
Unable to get the time difference
I have account column in Power BI and against each accountant I have their login and logout time in one column, both are getting differentiated based on the status, I want to find how many hours a da...
- Anonymous2 years ago
Hi akhan786 ,
Modify formula like below:
Result = VAR curIndex = 'Data'[Index] VAR loggedOutTime = CALCULATE ( MAX ( 'Data'[EndTime] ), FILTER ( ALLEXCEPT ( 'Data', 'Data'[Account] ), 'Data'[Index] = curIndex - 1 && 'Data'[Login State] = "Logged Out" ) ) RETURN DATEDIFF ( loggedOutTime, IF ( ISBLANK ( loggedOutTime ), BLANK (), 'Data'[EndTime] ), MINUTE )Best Regards,
Adamk KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.