Cummulative Bar Chart up to last datapoint

[Anonymous]

Hi,

I am trying to create a cummulative bar chart showing the value of quotes by each month for 2021 (orange) and 2022 (blue). I have the cummulative figures for both years by doing a 'running total' quick measure using Gross Value with "proposal sent date" as the date field being used here.

The latest data I have for a proposal is April 2022, but I want the graph to show me all of 2021 (cummulative) but 2022 to show only up to April (and May once a new datapoint arrises, i.e a proposal in May 2022).

Can I have some help with this please? Thanks

[amitchandak · Accepted solution]

@Anonymous , forced YTD and LYTD ?

YTD QTY forced=
var _max1 = today() //or maxx(allselected('Order'),'order'[Date])
var _max = format(_max,"MMDD")
return
calculate(Sum('order'[Qty]),DATESYTD('Date'[Date]),filter('Date', format('Date'[Date],"MMDD")<=_max))

YTD QTY forced=
var _max = today()
return
if(max('Date'[Date])<=_max, calculate(Sum('order'[Qty]),DATESYTD('Date'[Date])), blank())
//or
//calculate(Sum('order'[Qty]),DATESYTD('Date'[Date]),filter('Date','Date'[Date]<=_max))
//calculate(TOTALYTD(Sum('order'[Qty]),'Date'[Date]),filter('Date','Date'[Date]<=_max))

LYTD QTY forced=
var _max = date(year(today())-1,month(today()),day(today()))
return
if(max('Date'[Date])<=_max, CALCULATE(Sum('order'[Qty]),DATESYTD(dateadd('Date'[Date],-1,year)),'Date'[Date]<=_max), blank())
//OR
//CALCULATE(Sum('order'[Qty]),DATESYTD(dateadd('Date'[Date],-1,year)),'Date'[Date]<=_max)
//TOTALYTD(Sum('order'[Qty]),dateadd('Date'[Date],-1,year),'Date'[Date]<=_max)