Forum Discussion

CMMkamil's avatar
CMMkamil
Frequent Visitor
4 years ago
Solved

How to set date filter to previous month?

Hello,   Probably very simple but I can't seem to find a way for the life of me.    Basically I have two cards, one is showing the total profit in the current month(February) and I want the other...
Need Help
  • AmberJane's avatar
    AmberJane
    4 years ago

    You should have an option for the last "Calendar month".

Pbiuserr's avatar
Pbiuserr
Icon for Post Prodigy rankPost Prodigy
4 years ago

Hi, 
You can create new column in your calendar table to highlight previous month


Period = Switch( True(),
eomonth(Date[Date],0) = eomonth(Today(),-1),"Previous month" ,
Format(Date[Date],"MM YYYY"))

and then, when the date changes, previous month will move along. Simply use it as a filter for the card