Change month number used in a measure by a slicer

[dydx]

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?

[amitchandak · Accepted 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")

[amitchandak · Accepted 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")

[dydx · Accepted solution]

thank you for the prompt reply, i was able to get the value i wanted using

format(maxx(allselected('Date'), 'Date'[Date]), "M")