Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Filtering out Empty Dates in Forecasting

I am trying to track production of construction based off piece counts installed per day. I have only tracked a week of progress, but it sums up all of my piece counts from dates that have blank installations. How can I right a measure on my running total to be able to forecast my production.

 

I am using the following formula to create the running total. 

 

Running Total Instance Count =
Calculate(
Sum('Grid Data'[Instance Count]),
Filter( ALL ('Grid Data'), 'Grid Data'[Date_Installed]
<= MAX('Grid Data'[Date_Installed]))
)
Need Help

1 Reply

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    Hi Anonymous 

    Could you show an example and the rule for forecasting?

     

    Best Regards
    Maggie