Forum Discussion

NMC20's avatar
NMC20
Helper I
1 year ago

Projected Revenue Based on Average Per Day

I have managed to get an [Average Sales Per Day] in my data set, along with [Days Until Project End] and, based on those two fields, [Total Projected Reveue] for the project.    However, I was hopi...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi NMC20 ,

 

Usually, we often create the following measure to return the cumulative sum:

actual cumulative sales =
CALCULATE (
    SUM ( 'Table'[Sales] ),
    FILTER ( ALLSELECTED ( 'Table' ), [Date] <= MAX ( 'Table'[Date] ) )
)

 Here's the example based on some dummy data:

You can download my attachment for more details.

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.