Previousmonth

Hello nicoams 

My understanding is that in the slicer you have used Month in text format. And in your calendar you will have multiple values for Jan, Feb, etc. When you are selecting Apr from the slicer, the return table will give apr of 2019 & 2020 as well, but for PREVIOUSMONTH, it requires one date as an input.

Same is not happening when you are selecting it from the table visual, as you have year included in the visual. When you select Apr in the table visual, it is essentially selecting Apr of 2020, hence you are getting the result.

May I suggest

• either you use an additional slicer for Year along with Month, or add Year in the slicer
• or you can use a month(in date format) in the slicer

Cheers!

Vivek


If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂 (Hit the thumbs up button!)

If it doesn't, then please share a sample data along with the expected results (preferably an excel file and not an image)

https://www.vivran.in/

Connect on LinkedIn
Follow on Twitter