Forum Discussion
Highlight or Show Only specific months
Hi, I have a request from my user, they'd like to see the sales in very specific months instead of the timeline for the past 13 months. I'm currently using this measure as a viz level filter: ...
Anonymous , A measure like this should help.
Assuming 13 months are selected
calculate([measure], filter(Date, eomonth(Date[Date],0) = eomonth(today(),0) || eomonth(Date[Date],0) = eomonth(today(),-1) || eomonth(Date[Date],0) = eomonth(today(),-12)))
amitchandak
Super User
Super UserAnonymous , A measure like this should help.
Assuming 13 months are selected
calculate([measure], filter(Date, eomonth(Date[Date],0) = eomonth(today(),0) || eomonth(Date[Date],0) = eomonth(today(),-1) || eomonth(Date[Date],0) = eomonth(today(),-12)))
Thanks!
That worked for the most part. Is there any way in which I could include last december in there?