Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 |
---|---|
123 | |
70 | |
67 | |
58 | |
53 |
User | Count |
---|---|
186 | |
93 | |
67 | |
63 | |
54 |