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 LAD Funding]),FILTER(ALL('Date'),'Date'[Date]<=MAX(InvoiceDetails[Month invoiced])))
Budget Cumulative = CALCULATE(SUM(Spendperlot[Total]),FILTER(ALL('Date'),'Date'[Date]<=MAX(InvoiceDetails[Month invoiced])))
The figures are contained in separate tables and should include all of the values in those tables.
Chart looks like this.
I've set up a date table following this guide https://docs.microsoft.com/en-us/power-bi/guidance/model-date-tables and looks like this for example:
Data in the Month Invoiced table looks like this
There is a relationship with "month invoiced" and "Date" so it works perfectly if i wasn't trying to make a cumulative line chart.
Has any one got ideas to why this isn't working properly?