Forum Discussion

johnnyboy_175's avatar
johnnyboy_175
Frequent Visitor
5 years ago

Conditional forecast / runrate

I have followed Sam's tutorial https://blog.enterprisedna.co/how-to-calculate-a-cumulative-run-rate-in-power-bi-using-dax/   I have compiled the measures, my problem is I want the forecast measure...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi johnnyboy_175 ,

 

I don't quite understand the first question, better to share some sample data and expected result to us.

For the second question, you may use IF() function, like below:

IF([forecast]=0,value,[forecast])

 

 

Best Regards,

Jay