Count numbers of days an employee worked

Anonymous — Fri, 22 Jul 2022 11:02:20 GMT

hello I want to find the total days my employee worked, what is the formula for power bi given i have 2 tables , i want to create the column in the employee table , and the other table has list of daily attendance of each employee.

so this is my attendance table:

id- name- absent

1 -ari -True

1 -ari -Present

2 -james -True

2 -james -Present

i want in the employee table to add the days worked column to have:

id -name -days worked

1 -ari -2

2 -james -1

Re: Count numbers of days an employee worked

Avantika-Thakur — Fri, 22 Jul 2022 12:58:08 GMT

Hi Anonymous ,

Assuming that there's a relationship between the Attendance Table and Employee Table based on the ID column,

you can try creating the below measure -

Measure = calculate(count(Attendance),ALLEXCEPT(Table,Table'Name'),filter(Table,Attendance = "Present"))

Hope this helps.

Please accept the solution if this answers your query

Thanks!

Avantika

topic Re: Count numbers of days an employee worked in DAX Commands and Tips

Count numbers of days an employee worked

Re: Count numbers of days an employee worked