topic Re: Automatically change date based on actual Week & Month in DAX Commands and Tips

Automatically change date based on actual Week & Month

Anonymous — Sun, 18 Oct 2020 23:57:09 GMT

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.

Re: Automatically change date based on actual Week & Month

amitchandak — Mon, 19 Oct 2020 01:29:43 GMT

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.

Re: Automatically change date based on actual Week & Month

Anonymous — Mon, 26 Oct 2020 02:35:54 GMT

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

Re: Automatically change date based on actual Week & Month

Anonymous — Mon, 26 Oct 2020 04:56:17 GMT

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