how to filter data on last 3 monts

[Anonymous]

Hello experts,

I need some help with some simple things(for some people).

I managed to make a graph with series for 4 years by month. I would like to show in graph only data last 3 months

For example to see now only months March, Feb and Ian. But if I run report in August  to see August July and June for all 4 series.

Thank you

[Anonymous · Accepted solution]

Actually I realized that is quite simple

:

IsInFilter = IF(SalesQry[Posting_Date].[MonthNo]=MONTH(TODAY()) || SalesQry[Posting_Date].[MonthNo]=MONTH(edate(TODAY(),-1)) || SalesQry[Posting_Date].[MonthNo]=MONTH(edate(TODAY(),-2)) ,TRUE(),FALSE())

[v-jiascu-msft]

Hi @Anonymous,

That's great! Please mark your answer as solution.

Best Regards,

Dale