Previous Month Function- DAX

[chandni90]

Hi,

I have a dataset with names and the hiring dates. I also have a calendar table. I am trying to simply find the number of people who joined last month by using the previous month function. However, the previous month funtion is not returning any value. Please help to solve this. Thanks!

Previous month head count = CALCULATE(COUNT(Sheet1[Name]),PREVIOUSMONTH('Sheet1 (2)'[CalendarDate]))

[Anonymous]

First, your tables are BADLY NAMED. Good naming is of paramount importance in any programming activity.

Secord, your formula doesn't work because you should always check what arguments a function takes.

Please see: www.daxguide.com/count

Best
D.

[chandni90]

This is dummy data. The count function works fine when I calculate the total head count.

[Anonymous]

PREVIOUSMONTH -> Returns a table that contains a column of all dates from the previous month, based on the first date in the dates column, in the current context.

This might be the cause of your problem. The above function works OK when used on a day or a month level. Anything of lower granularity and you've got a problem.

Best
D.