Measure for sum of last month revenue

[Anonymous]

Hi,
I have a measure that calculates full monthly revenue based on specified dates, for example October:
Rev2020-10-Qta&NRMUsg = CALCULATE(SUM(Transactions[DailyUsage$NRMusg])

, DATESBETWEEN(Dates[Date],

DATE(2020,10,1),

DATE(2020,10,31)

))
This measure is used on some Power BI pages that don't have any slicers or applied time periods.

How can I build a dynamic measure that would return the same value, without having to "hard code" the dates? I've tried PreviousMonth and other functions, but could not set it up properly to work with those requirements:
- Previous Month should be calculated based on the current month, as of today
- It will not get the value from a slicer or a filter on the page
- Must be the entire full last month

Thanks for your help!
Erik

[Anonymous · Accepted solution]

Found it via another post on this forum. Here's the equivalent formula:

RevLastLmonthQta&NRMUsg = CALCULATE(SUM(Transactions[DailyUsage$NRMusg]),

DATESBETWEEN(Dates[Date],DATE(YEAR(TODAY()),MONTH(TODAY())-1,01),DATE(YEAR(TODAY()),MONTH(TODAY()),01)-1))