Forum Discussion
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. Howe...
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.
Secord, your formula doesn't work because you should always check what arguments a function takes.
Please see: www.daxguide.com/count
Best
D.
This is dummy data. The count function works fine when I calculate the total head count.
- 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.