Forum Discussion

johnnyboy_175's avatar
johnnyboy_175
Frequent Visitor
5 years ago

Cumulative Forecast - S Curve Chart Data

I have followed Sam's tutorial https://blog.enterprisedna.co/how-to-calculate-a-cumulative-run-rate-in-power-bi-using-dax/   Ideally I need a filter or IF statement where if Actual ISNOTBLANK then...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi johnnyboy_175 ,

Could you please help check whether the below understanding is correct or not?

1. You want to get two fields: [Forecast] and [Target (cumulitive)]?

2. The calculation logic of these fields as below:

Forecast= if ( the value of field [Daily Actual] is not blank, blank(),[Forecast]+[Run rate])
[Target (cumulitive)]=if( [Target (hard coded value)]is blank, not culmulative, cumulitive+Target (hard coded value))

3. The first value of [Forecast] 6897 and [Target (cumulitive)] 10688 is default value or the value from the calculation?

If my understanding is correct, here are some similar threads, you can refer them to get it.

Cumulative sum by date by condition

Cumulative sum with condition

Best Regards

Rena