topic Re: Previous Month Function- DAX in DAX Commands and Tips

Previous Month Function- DAX

Anonymous — Thu, 29 Aug 2019 20:51:28 GMT

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

Re: Previous Month Function- DAX

Anonymous — Fri, 30 Aug 2019 12:19:02 GMT

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.

Re: Previous Month Function- DAX

Anonymous — Fri, 30 Aug 2019 13:00:39 GMT

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

Re: Previous Month Function- DAX

Anonymous — Fri, 30 Aug 2019 14:54:54 GMT

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.