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.
I have a measure that uses the number of months left in a year for exampe A/(12-current month),
Is it possible have a slicer that changes the current month from (10) for october to whatever month selected, (8) for August?
if it is how can i do i go about it?
Solved! Go to Solution.
@dydx , Not very clear you can have column like this in you 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")
)
and you can display in meaure like
format(maxx(allselected('Date'), 'Date'[Date]), "MMM-YYYY")
thank you for the prompt reply, i was able to get the value i wanted using
format(maxx(allselected('Date'), 'Date'[Date]), "M")
@dydx , Not very clear you can have column like this in you 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")
)
and you can display in meaure like
format(maxx(allselected('Date'), 'Date'[Date]), "MMM-YYYY")
thank you for the prompt reply, i was able to get the value i wanted using
format(maxx(allselected('Date'), 'Date'[Date]), "M")
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |