Forum Discussion
Super UserMTD questions
Community ChampionI think you should be using the PREVIOUSMONTH function:
PREVIOUSMONTH will work, but I have to ask if that date format is supported? It must be, since CurrentMTD is working.
- parry2k
Somehow my reply disappeared, seems like previous month is for full month not MTD. So in that case, do i have to have two measures, one for previousmonth and one for MTD
- parry2k
As per the description in previousmonth function, it will return all dates for the month and in that case MTD will not work.
Here is the what is says on this link https://support.office.com/en-US/article/PREVIOUSMONTH-Function-DAX-72fb8dda-6cd6-49e6-b9b4-8a5f632439c2
This function returns all dates from the previous month, using the first date in the column used as input. For example, if the first date in the dates argument refers to June 10, 2009, this function returns all dates for the month of May, 2009.
- Greg_Deckler
Use PARALLELPERIOD with month as the interval and -1.
You would use DATESMTD function as your dates input
