I’m still working through Sam’s “beginner dax course.” But as of yet, I have not been able to figure this out (at all). Excel gives me the correct answer as shown below. But not Power Bi. Could someone please help correct my People Count dax formula so that it gives the correct answer?

Thank you both for your replies. However neither are correct as they both imply that an employee only works one day in a month. As soon as I make “Michelle” work 3 days in July, the numbers become incorrect. But again with excel… it’s perfectly correct. I’m open to “re-shaping” my employee / employeehours table into a better design if this is what is needed.

I’m bit confused because @Melissa’s formula and my formula shows the identical result as shown in the Excel file. Below are the screenshots provided for the reference -

Sorry… let me ask it another way. I need a power bi table which answers the question: “How many employees worked for us during each month?” One row of data is one day worked by an employee, they can work multiple days in a month. I got my excel pivot wrong myself, but now it is right for sure. I need to replicate this in power bi.

Hi there. Again, thank you for the prompt and comprehensive replies. This forum is really great. I also got an alternative answer which is easier for to understand and so far completely error proof on a 40,000 row data set. I’ll post it here just in case it is of use to anyone else: