Show sum of YTD only from Today's date forward

[Anonymous]

I have order information where some orders have a wanted delivery date in the past and some in the future.

I have created a measure that returns the sum of the late orders, I have also been able to create a measure that only shows the orders that have a future delivery date. I have a dimDate table that I use for my axis.

Where I need help is that I want to show the sum of the late orders only for today's and future dates and not for any past dates. In the end I'm thinking of a stacked bar chart or similar with the late orders and the future orders but the dates start at Today.

I can make it happen by filtering the visual for dates before today, but ideally, I want the measure to return 0 for any date before today and the late order value for today and future dates.

Thank you for any help you can provide.

[lbendlin]

I want the measure to return 0 for any date before today and the late order value for today and future dates.

 What have you tried and where are you stuck?

[Anonymous · Accepted solution]

Thank you for asking. I was able to come up with a measure that gives me the data the way I need.

IF(
	MAX(dimDate[Date]) >= TODAY(),
		CALCULATE(
			sum(fctPOLines[Quantity]),
			dimDate[Date] <= TODAY()
		)
	)