Sum from beginning of quarter to today's date

[n5722]

Hello,

I don't know how to do the following so could someone please give me some advice? I already checked multiple forum posts regarding similar issues but I could not implement it in a way that works.

In the graph above (which shows the period of Q2) I want to calculate:

- the sum of the dark blue area (named "actual") that should start from the first day of the quarter and end on today's date
and add that to the
- sum of the light blue area (named "forecast") that should start from today's date and end on the last day of the quarter

Both of them are connected to a Date Helper table.

Any advice would be much appreciated!

Thanks!

[Anonymous · Accepted solution]

Hello @n5722 ,

Create below measures,

Max Date QTR Start =

DATE ( YEAR(MAX('Date'[Date])), ROUNDUP ( DIVIDE ( MONTH (MAX('Date'[Date])),3 ),0 ) *3 -2, 1)

Max Date Qtr End =

EOMONTH ( [Max Date QTR Start],2 )

Actual =

CALCULATE(Sum('Table'[Actual]),DATESBETWEEN('Date'[Date],[Max Date QTR Start],TODAY()))

Forecast = 

CALCULATE(Sum('Table'[Forcast]),DATESBETWEEN('Date'[Date],TODAY(),[Max Date Qtr End]))

[n5722]

Works like a charm! Thank you so much!