Override date filter in Power BI with months before the filtrate

[Anonymous]

Hi,

I'm trying to make sure that when I filter the month, the table returns the 5 months before that filtered month.
I'm new to dax language and I don't have so much advanced knowledge and I found a way to solve this link:

https://towardsdatascience.com/override-date-filter-in-power-bi-743b9e8b9b2

What I did was create this measure

Value of docs -5 month = VAR MaxDate = MAX (Date [Date])
VAR MinDate = DATE (YEAR (MaxDate), MONTH (MaxDate) -5, DAY (MaxDate))
VAR Result = CALCULATE (
DISTINCTCOUNT (Table [DOC_ID]),
FILTER (table,
table [Date]> = MinDate && table [Date] <= MaxDate)
)
RETURN
Result

the table [data] is the main date of my data table

and the date [date] is a table just like the date, as if it were a fatto table

You are returning the last 5 months regarding the maximum date not what was filtered, how would you do this measure to solve this?

[jameszhang0805]

Returns the Last N months regarding the selected month. Hope it is useful to you.

 Last N Month.pbix 

[rfigtree]

try changing the filter in your return to this

FILTER (     all(table)     ,Table [Date]> = MinDate && table [Date] <= MaxDate)