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 to show the previous month so January in this case. But I want those to update automatically at months move on. 

 

For the first card I simply have the filter set to "Show items when the value: is in this month"

 

But how do I set it for the previous month i.e. January and not last 30 days?

 

Many thanks,

 

Kamil

Need Help

5 Replies

  • AmberJane's avatar
    AmberJane
    Icon for Helper III rankHelper III
    4 years ago

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

    • CMMkamil's avatar
      CMMkamil
      Frequent Visitor
      4 years ago

      It turns out that I'm just very blind. Sorry and thank you. 

      • AmberJane's avatar
        AmberJane
        Icon for Helper III rankHelper III
        4 years ago

        Not at all! I got stuck on this too with week and month haha! 

  • 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

  • ITManuel's avatar
    ITManuel
    Icon for Responsive Resident rankResponsive Resident
    4 years ago

    Hi,

     

    you could apply the filter in the calculation not in the Filter pane.

     

    CALCULATE("Total profit"), PREVIOUSMONTH('Date'[Date]))

     

    Br