Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Previous Month Function- DAX

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]))
DAX
DAX Query

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago
    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.
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago
        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.