Forum Discussion

damomac85's avatar
damomac85
Frequent Visitor
9 years ago
Solved

Cumulative formula issue

I have a budget , an actuals and a date table which i am using to show a monthly Cumulative line chart for monthly budget vs actual data.   i have added the the follwing measure for a budget Cumula...
Reports
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    damomac85

     

    Please try with following measure formula.

     

    Cumulative Net = 
CALCULATE (
    SUM ( 'tbFactProspectWon'[NetPrice] ),
    FILTER ( ALL ( 'Date' ), 'Date'[Month] <= MAX ( 'Date'[Month] ) )
)

     

    Best Regards,

    Herbert

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

damomac85

 

Please try with following measure formula.

 

Cumulative Net = 
CALCULATE (
    SUM ( 'tbFactProspectWon'[NetPrice] ),
    FILTER ( ALL ( 'Date' ), 'Date'[Month] <= MAX ( 'Date'[Month] ) )
)

 

Best Regards,

Herbert