Flag Latest Month True in my date Column

[Selded]

Hi All, 

Kindly assist me write a calculated column in my date table that will return latest month true. i will use this as a filter in my report to return values for only lastest month in my visuals. Below is a **bleep** of my date table.

Thanks for the help.

[amitchandak]

@Selded ,  Hope I get it correctly. You need to add a column like this in the date table

Month Type = Switch( True(),
Date([Date]) = eomonth(Today(),-1),"Last Month" , //Last Month
Date([Date])= eomonth(Today(),0),"This Month" , //This Month
[Month Year]
)

[lkalawski · Accepted solution]

Hello @Selded ,

You can use this calculated column:

Latest month = 
IF (DATE(YEAR(TODAY()), MONTH(TODAY()) - 1, 1) = STARTOFMONTH('Date'[Date]), "Latest Month")
 
Current month = 
IF (DATE(YEAR(TODAY()), MONTH(TODAY()), 1) = STARTOFMONTH('Date'[Date]), "Current Month")
 

_______________
If I helped, please accept the solution and give congratulations! 😀