How to create filter for certain number of months?

[aviswana27]

How can I create a filter that shows only the last 3 months of a date field?  I have a column of data called Created Date and in a specific dashboard/component I want to show data for the last three months.  Instead of manually selecting the last three months every month was hoping to create a formula of some sort so that the dashboard components update each month on it's own.  Is this possible?

Thanks,

Arun

[v-caliao-msft]

Hi @aviswana27,

Create a calculated to check if the date is under the last 3 month or not, and then drag this new created calculated into a slicer visual to filter the data.

Last3Month = IF(AND(YEAR(TODAY())=YEAR('Date'[CalendarDate]),(MONTH(TODAY())-MONTH('Date'[CalendarDate]))<3),"Last 3 month","Other")

Regards,

Charlie Liao

[Greg_Deckler]

MonthsAgo=DATEDIFF(TODAY(),[Created Date],MONTH)

Create as a new column and then use that to filter < 2.

If you need year factored in, you might have to do some slighly more complicated calculations.