Forum Discussion

DLJ's avatar
DLJ
Frequent Visitor
6 years ago
Solved

Calculate Total Expenses Excluding Current Month

Hi All,   I want to show a bar chart comparing month by month 2 different measures: a) Total actual expenses (from the origin to the last month extracted -but excluding the current month-) b) Tot...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    you could create a custom column like this:

     

    IsCurrentMonth = 
    IF (
        YEAR ( Table[Date] ) = YEAR ( TODAY () )
            && MONTH ( Table[Date] ) = MONTH ( TODAY () ),
        "Yes",
        "No"
    )

     

     

    and then filter the visual on this column -> IsCurrentMonth = "No" 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

you could create a custom column like this:

 

IsCurrentMonth = 
    IF (
        YEAR ( Table[Date] ) = YEAR ( TODAY () )
            && MONTH ( Table[Date] ) = MONTH ( TODAY () ),
        "Yes",
        "No"
    )

 

 

and then filter the visual on this column -> IsCurrentMonth = "No" 

DLJ's avatar
DLJ
Frequent Visitor
6 years ago

Thank you very much. It works perfectly!