Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
Hi @Neha_Shukla ,
I added a few rows of date and Emp columns to your original table.
1.Merge Complete Date and ActivityTime columns, Modify the date type to Datetime. Then sort directly.
DateTime =
CONVERT ( 'Table'[Complete Date] & " " & 'Table'[ActivityTime], DATETIME )
2.Create a measure and group by max and min. Change the format.
Total working hours =
VAR _min =
CALCULATE (
MIN ( 'Table'[DateTime] ),
FILTER ( ALL ( 'Table' ), 'Table'[Emp] = MAX ( 'Table'[Emp] ) )
)
VAR _max =
CALCULATE (
MAX ( 'Table'[DateTime] ),
FILTER ( ALL ( 'Table' ), 'Table'[Emp] = MAX ( 'Table'[Emp] ) )
)
RETURN
_max - _min
Best Regards,
Jinwei Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Neha_Shukla , You have two value which is getting the same sort of order that is not allowed
Something like this
Column | Sort |
A | 1 |
B | 1 |
C | 2 |
That is not allowed
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c
1. I want to sort out activity time column as per latest time entry.
On activity type column there are values containing ( check - in , lunch - time, lunch- over, break- time, end- break , check-out)
2. AS per this activity which are done by employee I want to find out total working hours.
how to solve this.please help me out in this.
thanks in advance.
User | Count |
---|---|
93 | |
92 | |
85 | |
83 | |
49 |
User | Count |
---|---|
150 | |
142 | |
112 | |
73 | |
55 |