Press "Enter" to skip to content

Building a Cumulative Target in DAX

Gilbert Quevauvilliers uses DAX to calculate a straight-line target:

I had a requirement to take the overall target amount and split it for each month. But also, for it to be cumulative for each month going forward.

The Target amount was 600,000 per month

This is what the DAX measure looked like

Click through for the DAX as well as an example image to tie it together.