Get Previous Month's Name

[Xandman]

I'm trying to get the previous month's NAME of a selected date to appear on a card but, I always get an error when I use this:

PreviousMonName = FORMAT(PREVIOUSMONTH(DateTable[Date])-1,"MMMM")

Hope someone can guide me on why this isn't working.

I'm also planning on getting the previous 2 to 6 months on a card as a label.  I got the previous month value to work with:

SubPreviousMonth = CALCULATE([Total Subs],PREVIOUSMONTH(DateTable[Date]))

Still trying to find a way to get the 2 to 6 months previous to it.

[amitchandak · Accepted solution]

@Xandman , Try like

calculate(FORMAT(max(DateTable[Date]),"MMMM"),PREVIOUSMONTH(DateTable[Date]))

Try like

SubPreviousMonth = CALCULATE([Total Subs],PREVIOUSMONTH(DateTable[Date]))

2nd SubPreviousMonth = CALCULATE([Total Subs],PREVIOUSMONTH(dateadd(DateTable[Date],-1,month)))

last MTD = CALCULATE([Total Subs],DATESMTD(dateadd('Date'[Date],-1,MONTH)))

[Xandman]

Thank you! I used the same pattern to get the names too.