Formula for previous 2 months from 1st of month from getdate

[Fig1]

Hi there

I have this formula in my load script which brings through all data up to the end of the previous month.

Dischargedate < DATEFROMPARTS(YEAR(GETDATE()),MONTH(GETDATE()),1)

In my dashboard I need to show a section of data where we are comparing the last two months. 

I'm trying to create a formula where the discharge date is greater than the month(getdate()),1) minus two months.

I need a formula similar to this one but instead of todays date i need it to show two months prior from the end of month (month(getdate()),1))

=if(DischargeDate > add months(today(), -2),1,0) as FlagTwoMonths

Any suggestions welcome 🙂

[Muthukumar_77 · Accepted solution]

Hi,

=if(DischargeDate > AddMonths(MakeDate(Year(Today()),Month(Today()),01),-2),01) ,1,0) as FlagTwoMonths

[Fig1]

This worked perfectly.

Thank you!