Cumulative budget calcs with dynamic start date

DAX DAX Calculations
2

Hi @jsavage

I’d highly recommend adding a date table and creating a relationship between that and your data, @Melissa 's is great:
Extended Date Table (Power Query M function) - M Code Showcase - Enterprise DNA Forum

I then created this measure:

Cumulative Budget 2 = 
CALCULATE(
    SUM( Metrics[Daily Budget] ),
    FILTER( ALLSELECTED( Dates[Date] ),
    Dates[Date] <= MAX(Dates[Date] ) ) )

And changed the axis on the chart and the slicer to use the Date column from the Date table.

Please find the pbix below, hope this helps!

Template.pbix (227.7 KB)

2 Likes