Forum Discussion

Solans's avatar
Solans
Regular Visitor
3 years ago

Need help with Previous Month selector, selecting December

Hello,   I have a slicer on my visuals selecting the previous month, therefore excluding the current month. Now, the problem occurs when the new year begins. As you can guess the slicer will...
Need Help
Tips and Tricks
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Solans , Based on what I got. It would better to have month year slicer like

 

Month Type = Switch( True(),
eomonth([Date],0) = eomonth(Today(),-1*month(Today())),"Last year Last Month" ,
eomonth([Date],0) = eomonth(Today(),-1),"Last Month" ,
eomonth([Date],0)= eomonth(Today(),0),"This Month" ,

eomonth([Date],0)= eomonth(Today(),-1*month(Today()) ),"Last Dec" ,
Format([Date],"MMM-YYYY")
)

Solans's avatar
Solans
Regular Visitor
3 years ago

Hi,

 

Thanks for your reply, however this doesnt seem to work as intended.

 

For reference, I am trying to use the slicer on two visuals that show the count of tickets.

The first visual has to show the count of tickets for 2 different departments and for every month of this year.

The second visual shows the count of total tickets of the current year (of completed months) in comparison with last year.

Now the problem I have is that when it is Januari, the month selected is then December, The visuals then show the data of 2022, and I have to manually update the year to the next.

Picture for reference: