IF statement with FILTER

Hi Aden 

In order to filter on months before the current month, I would suggest using EOMONTH to get the last date of the previous month, then filter on dates <= that date. This can be wrapped in KEEPFILTERS to intersect with the current filter context.

Here is how you could write the measure:

(Note: I'm assuming your 'Calendar' table is marked as a date table, and 'Calendar'[trandate] is the date column.)

Fees % of Budget to last month 2 =
CALCULATE (
    DIVIDE ( [Net Fees], SUM ( 'Budgets'[billamt_perday] ) ) * 100,
    KEEPFILTERS ( 'Calendar'[trandate] <= EOMONTH ( TODAY (), -1 ) )
)

Does this give the expected result?

Regards,

Owen