SUM last business month

[joshua1990]

Hello everybody!

I would like to sum all the values for the last business month.

The business months have individual start and end dates.

That means I can't use previousmonth function.

How can I transfer that code for business months?

=var currentMonth = Month(today())-1
Return
CALCULATE(sum('DB'[Values]);'Calendar'[Business Month Number] = currentMonth)

[OwenAuger]

Hello @joshua1990 

Is Business Month Number a sequential value increments by one for each month across multiple years (for example Year*12 + Month)?

If it's not, I suggest you create such a column in 'Calendar' first.

Once you do you have such a Business Month Number column, you could write something like this:

=
VAR currentMonth =
    CALCULATE (
        MAX ( 'Calendar'[Business Month Number] );
        'Calendar'[Date] = TODAY ();
        ALL ( 'Calendar' ) // Not required if 'Calendar' is marked as a date table
    ) - 1
RETURN
    CALCULATE (
        SUM ( 'DB'[Values] );
        'Calendar'[Business Month Number] = currentMonth;
        ALL ( 'Calendar' )
    )

Regards,

Owen