Bar chart - YTD figures

[HEW]

Hi.

We have a bar chart where we show YTD Current year, YTD last year and YTD budget figures.

However, for the actual YTD figures we would like only to show figures for the previous and currents months. This means that for May-December the red bar should be empty. Is this possible?

The measure for Actual YTD is:

Net sales Local YTD:=CALCULATE(SUM(Invoices[NetSalesLocal]);DATESYTD('Month'[Date])) 

Thanks a lot in advance.

Br.

Helen

[amitchandak · Accepted solution]

@HEW 

First, you adjust the YTD to your financial year. Year from May -April will look like

YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(('Date'[Date]),"4/30"))

Also you can stop it max date of data
YTD Sales =
var _max = maxx(Sales,Sales[Sales date])
return
CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(('Date'[Date]),"4/30"),Sales[Sales date]<=_max)

[HEW]

@amitchandak 

It works perfectly - thanks a lot.

Br.

Helen