Forum Discussion
preparing employees attendance for reporting
I've the following table for user attendance each emplyee may has 1 or 2 or 3 or multiple records for each date what I need is: first step: list only the first checkin and last checkout t...
amitchandak
Super User
Super UserElmo22 ,Create a new column in table
Date = datevalue([Checkin])
You can create a new table like or measures or column
New = Summarize(Table, Table[User ID], Table[Date], "Start", Min([Checkin]),"End", Max([Checkin]) )
Join it with date table
Workday = countrows('New')
Non Workday = Countx(Summarize('New', [User ID], [Date]), if(isblank[Workday]), [User ID], blank()) )
thanks amitchandak for your replay.
I have a question.
what do you mean by "join it with date table"? do you mean by back to power query editor, or what.