Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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))
User | Count |
---|---|
65 | |
46 | |
20 | |
18 | |
15 |
User | Count |
---|---|
120 | |
41 | |
40 | |
28 | |
23 |