Automatically change date based on actual Week & Month

[Anonymous]

Hi everyone, 

I have a problem with month - week based results and i didn't find an option that allows me to show the results of each month in filter relative date, what i actually want is a filter that change automatically the actual month showing at the column header and the results, by example:

This is my current month and the past 5 months:

What i want is that in november the entire information changes automatically and shows me november results and past 5 months:
like this:

same thing with weeks, show the last 4 week year

I want to do it in the dimdate table

because there's a lot of values calculated and i want to avoid make a measure for each one, just do it like a date filter

Thank you very much for reading.

[amitchandak]

@Anonymous , For this best, is relative date filter.

Or you have to create a column like this in date table

Month Type = Switch( True(),
eomonth([Date],0) = eomonth(Today(),-1),"Last Month" ,
eomonth([Date],0)= eomonth(Today(),0),"This Month" ,
Format([Date],"MMM-YYYY")
)

Also, you have to use this approach of the trend with the above filter

https://www.youtube.com/watch?v=duMSovyosXE

Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.

[Anonymous]

Excellent, worked so well, how can i do that for the week year number? like Week 39, 40, 41, 42?

[Anonymous]

@Anonymous  Combinevalue(" ", "Week " , Weeknum(date(date))