Forum Discussion

mwinds's avatar
mwinds
Helper I
3 years ago

Cumulative line chart

Hi all,   I've having issues with this measure. The line chart is cumulative for some months but not for others. Here's what I've got.     Actual Cumulative = CALCULATE(SUM(InvoiceDetails[Total...
Need Help
amitchandak's avatar
amitchandak
Super User
3 years ago

mwinds , You should date/period from date table on axis and measure should be like

 

Budget Cumulative =
var _max = maxx(allselected(InvoiceDetails) , InvoiceDetails[Month invoiced])
return
CALCULATE(SUM(Spendperlot[Total]),FILTER(ALL('Date'),'Date'[Date]<=MAX('Date'[Date]) && 'Date'[Date]<= _max ))