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...
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.
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.