Urgent help needed - sum up sales forecast from today thru end of month

DAX DAX Calculations
1

Hello Forum - This may be an easy one, but I can’t figure it out.

I have sales forecast from our CRM system. I would like to sum up the total forecast opportunity from today thru to the end of this month (September), and of course it should be dynamic.

Any help is appreciated!

2

@richmont,

This should work for you:

Sales Forecasts Today to EOM = 
VAR StartDay = TODAY()
VAR EndDay = EOMONTH( TODAY(), 0 )
VAR DateRange =
    DATESBETWEEN( Dates[Date], StartDay, EndDay )

RETURN
CALCULATE(
    [Total Sales Forecasts],
    DateRange
)

Full PBIX attached below. Hope this is helpful.

  • Brian

eDNA Forum - Total Sales Forecasts EOM.pbix (110.7 KB)

2 Likes