Forum Discussion
Helper IIIBar chart - YTD figures
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
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)
2 Replies
- amitchandak
Super User
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