Hi David.  Can you post some sample data?  That would be helpful to better understand what you're looking at.

I'm thinking that what you're looking for is the "Group By" function.  You could use the Count function within Group By to count the number of staff, and then probably sum or average the measures you're trying to summarize.

Good Day

Sorry for not getting back sooner.

Attached is the sample data requested.

Thanks again for all your help.

Hi David,

It's not clear if you want a staff count by day, or whether the day data is irrelevant. If the date is irrelevant, then like Adam suggested, you can use the Group By function in Power Query to get the count after removing duplicate names. See attached.

If you were after something else, then please provide a mock-up of your desired result based on your sample file.

Mynda

Hi Mynda

Thanks for your reply.

I am trying to count the number of staff by department who are either late or absent in one report on a daily and monthly basis. In another report, by name, department for either late or absent and lost late time also daily and monthly. I would like to keep the date which can be month and year because I need to track monthly to monitor performance. See attached mock-up reports.

I hope this makes sense.

Dave

Hi David, the attached file contains the PT's you want.

Needed to transfer the dates to real dates using Text-to-columns and grouped the dates in the PT by month.

Riny

Hi Mynda

Please disregard my attachment as I forgot to add one report.

What I have attached is what is reported on a daily and monthly basis.

Dave

Hi Riny

Thanks I was not thinking I had not converted the dates from text to proper dates and I have grouped the dates. I was not thinking.

Thanks for the support.

Dave

Hi David,

It looks like Riny has answered your question. Please advise if not as I've lost track!

Mynda