LAST 6 MONTH MONTH (This Month to last 6 Month)

[Anonymous]

Hi Team,

I need last 6 month calculated column(not -180day)

IF(DATE>=MONTH(today())-6,"YES","No") its error

Mean i need 2020-May,2020-apr,2020-march,2020-feb,2020-Jan,2019-dec

Last 6 month mean i nedd 6 (Not today date to last 6 month,I need this Month to last 6 Month)

[amitchandak · Accepted solution]

@Anonymous , what you trying, seem like you need a column.

Try new column like

IF([DATE]>=date(year(today()),MONTH(today())-6,1),"YES","No")

IF([DATE]>=date(year(today()),MONTH(today())-6,day(today())),"YES","No")

[v-xicai · Accepted solution]

Hi @Anonymous ,

You may create calculated column like DAX below.

Column=IF(DATE>= EOMONTH(Table[Date],-7)+1 ,"YES", "No")

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@Anonymous , what you trying, seem like you need a column.

Try new column like

IF([DATE]>=date(year(today()),MONTH(today())-6,1),"YES","No")

IF([DATE]>=date(year(today()),MONTH(today())-6,day(today())),"YES","No")