Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
@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.
Excellent, worked so well, how can i do that for the week year number? like Week 39, 40, 41, 42?
@Anonymous Combinevalue(" ", "Week " , Weeknum(date(date))