DIm Date - Show Previous month in new column based on Date

[Anonymous]

Hi Expert

Need to amend the current measure so i can add to my Dim_Date table as a column to show the previous month. 

Calendar = ADDCOLUMNS ( CALENDAR (DATE (2000, 1, 1), DATE (2030, 12, 31)),

    "Year", YEAR([Date]),

    "MonthNo", MONTH([Date]),

    "Month", FORMAT([Date],"mmm"),

    "Quarter", FORMAT([Date],"\QQ"),

"YearMonth", FORMAT([Date],"YYYY-MM"),

    "WeekdayNo", WEEKDAY([Date],2), //1-Sun..Sat, 2-Mon..Sat

    "Weekday", FORMAT([Date],"ddd") )

[amitchandak · Accepted solution]

@Anonymous , if you only need last month

this will give last date eomonth([DATE],-1)

and you can use format to get that

format(eomonth([DATE],-1), "MMM-YYYY")

But for data use time intelligence

Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e

Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.

[Anonymous]

ManY Thanks