Showing Max Value in Matrix excluding last month

[mmh]

Hi, 

I would like show in MAX value in martix excluding last month. 

I have a measure as 

CALCULATE(
    Max(tables[sale_sum]), 
    FILTER(
        tables, 
        tables[date] < DATE(YEAR(MAX(tables[date])), MONTH(MAX(tables[date])), 1)
    )
)
But showing only one month exlcuding last month. I.e in matric row for customer account, column YearMonth and value for MaxValue

Thanks

[mmh · Accepted solution]

Hi @tamerj1  thanks for your reply. but it doesnt work. Anyway there is a function 

CLOSINGBALANCEMONTH and it works with this

[tamerj1]

Hi @mmh 

not 100% sure what the requirement is but please try

MaxValue =
MAXX (
FILTER (
SUMMARIZE ( tables, tables[Customer Account], tables[YearMonth] ),
tables[YearMonth] < MAX ( tables[YearMonth] )
),
CALCULATE ( SUM ( tables[sale_sum] ) )
)