Forum Discussion
superjam
Helper II
Helper IIPrevious month not working
Hi, If you could please help me out with this error: I have a sales table (with sales of several years back) and the corresponding calendar table. All I need is the count of sales for the previo...
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!
superjamHelper II
Helper IISorry, I mentioned that the Previousmonth formula returned a blank result; actually the result is zero.
CALCULATE( [Sales count],
PREVIOUSMONTH( Calendar[Date] ) )