Calculate Employees on the First Day of the Month

Question

Hi

I have created a DateDimenionTable and marked it as a Date Table and trying to get the count of of employees as of month starting , I am getting an error too many arguments were passed to the count function.

Please let me know what should be the correct expression

=OPENINGBALANCEMONTH(count(EmpDataMonthWiswe[Emp no],DimTime[Date]))

Thanks,Gautam

Answer 1

Try:

=OPENINGBALANCEMONTH(count(EmpDataMonthWiswe[Emp no]),DimTime[Date])

HTH!

David Hager

Excel FMVP

Answer 2

Hello,

You can aslo look into the following articles about Count() and OPENINGBALANCEYEAR functions:
COUNT Function: http://technet.microsoft.com/en-us/library/ee634791.aspx
OPENINGBALANCEMONTH Function (DAX): http://technet.microsoft.com/en-us/library/ee634224(v=sql.105).aspx

Regards,
Bin Long

---

Bin Long

TechNet Community Support