Forum Discussion
Helper IIPrevious month not working
Wow, I just solved it! (sorry for bothering you, ...good for me)
The reason why the previous month formula returned a zero value is because I needed to give it the today parameter in the filter. Forgot to mention that I displayed the value in a card (not a table). When I apply a filter to the card so as date = today, then the correct value comes up.
Must be very basic for the most of you, but I am so glad to have solved it!
Helper IISorry, I mentioned that the Previousmonth formula returned a blank result; actually the result is zero.
CALCULATE( [Sales count],
PREVIOUSMONTH( Calendar[Date] ) )
Helper IIWow, I just solved it! (sorry for bothering you, ...good for me)
The reason why the previous month formula returned a zero value is because I needed to give it the today parameter in the filter. Forgot to mention that I displayed the value in a card (not a table). When I apply a filter to the card so as date = today, then the correct value comes up.
Must be very basic for the most of you, but I am so glad to have solved it!