Filter on Last 6 Months

[joshua1990]

Hello everyone!

I have a basic calendar that contains columns like date, week, year and month - always as numbers.

Now I need a filter - based on a calculated column - to filter on the last 6 months.

How would you build that for a calculated column?

[amitchandak]

@joshua1990 ,

New column =

if([Date]>=date(year(Today),month(Today)-6,day(Today)), "Last 6 Month","Other")

[camargos88]

Hi @joshua1990 ,

Try this code for a new calculated column:

Filter = IF(DATEDIFF('Table'[Date]; TODAY(); MONTH) <= 6; 1; BLANK())

Did I answer your question? Mark my post as a solution!
Ricardo