Power BI Measure Calculation for Previous Month until D-1

[Magliari]

Hello Power BI community,

I hope you're all doing well. I have a specific measure, $ RECEITA PERFORMANCE, in my Power BI report. The data source includes a calendar table (D_Calendario) with a column named Date.

I'm trying to create a calculation for this measure that considers the revenue for the previous month up to the day before today's date. For instance, if today is 03/02/2024, I want the measure to display the revenue for the previous month until 02/01/2024.

I already have a filter in place using the Year Month column, which follows the format "Feb 2024." This allows me to select the desired month and year for analysis.

Could anyone provide guidance on how to achieve this calculation in Power BI? Your help would be greatly appreciated!

[lbendlin · Accepted solution]

EDATE(TODAY(),-1)-1

[Magliari]

Thank you!

I did in this way:

CALCULATE(
    [$ RECEITA PERFORMANCE],
    DATESBETWEEN(D_Calendario[Date],(EOMONTH(TODAY(), -2) + 1),(EDATE(TODAY(),-1)-1)
))