Forum Discussion
rains_23
Helper I
Helper IAttendance or count based on 2 fields
Hi, I have a table, as below and I need to count the employee attendance for the whole month. I want the answer as ABC =3, PQR=4, CDF=3. If I use the count of (Login date) in a matrix it gives corre...
Selva-Salimi
Solution Sage
Solution SageHi rains_23
first add a column to your table as follows:
year_month= format( date , 'YYYYMM')
and then write a measure as follows:
measure employee_count := var tbl = summarize (table , division, employee , year_month ,"cnt", count (employee))
return
sumx(tbl , cnt )
If this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly.