DAX Command for SUMIF Type Format

[maxse]

I'm trying to create a DAX formula that will return the SUM of 'Invoice_Amount' for any date in the current month. Then another formula for the SUM of 'Invoice_Amount' for any date in the prior calendar month. Any help would be appreciated.

LastMonthBilled = SUMX(FILTER(CWInvoices,CWInvoices[Date_Invoice]>=TODAY()-30), CWInvoices-CWInvoices[Invoice_Amount])

[FreemanZ]

hi @maxse 

try like:

AmtCurrentMonth = 

CALCULATE(

    SUM(TableName[Invoice_Amount]),

    MONTH(TableName[Date]) = MONTH(TODAY()) 

        &&YEAR(TableName[Date]) = YEAR(TODAY()) 

)

AmtLastMonth = 

CALCULATE(

    SUM(TableName[Invoice_Amount]),

    MONTH(TableName[Date]) = MONTH(EDATE(TODAY(), -1)) 

        &&YEAR(TableName[Date]) = YEAR(EDATE(TODAY(), -1)) 

)