IF formula with dates

Hi NvdV1986 

In Power BI you don’t need to hardcode month numbers, you can make it dynamic with EOMONTH and TODAY(). Try this as a calculated column:

MonthFlag = 
VAR InvDate = [Entry date]
VAR ThisMonth = EOMONTH(TODAY(), 0)
VAR LastMonth = EOMONTH(TODAY(), -1)
VAR TwoMonthsBack = EOMONTH(TODAY(), -2)
RETURN
    SWITCH (
        TRUE(),
        EOMONTH(InvDate, 0) = ThisMonth,       "Current month",
        EOMONTH(InvDate, 0) = LastMonth,       "Last month",
        EOMONTH(InvDate, 0) = TwoMonthsBack,   "Two months back",
                                               "Other"
    )

Outcome : 

Great it works!!!! Thanks!