Attendance in time out time

[rajasekar_o]

hi team i need help,
i have the data , need  to calculate in time and out time 

I need the output 

i try but not able to get output 

[Anonymous · Accepted solution]

Hi @rajasekar_o 

You can create a calculated column in table

date = [datetime].[Date]

Then create the following measures

in time = CALCULATE(MIN('Table'[datetime]),'Table'[type]=0)

out time = CALCULATE(MAX('Table'[datetime]),'Table'[type]=1)

Then put them to the visual filter.

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Daniel29195]

Hello @rajasekar_o

you can achieve this output with power query .

follow these steps : 

i took example this sample data : 

step 1 :  select the column you want to transform it into columns. 

step2 :  go to transform --> pivot

step3 : choose for value column, the values that you want to be under each pivoted column

and aggregate you can set to dont aggregate 

final result : 

If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. Dont forget to hit that thumbs up button 🫡👍