Forum Discussion

Whitney's avatar
Whitney
Helper II
5 years ago

Rolling average forecast

Hi,   I received great assistance on this thread however, I can't figure out how to use the solution to create the forecast I desire in future months.   https://community.powerbi.com/t5/Desktop/R...
Need Help
lbendlin's avatar
lbendlin
Super User
5 years ago

Would you mind mentioning the errors you are experiencing?

Whitney's avatar
Whitney
Helper II
5 years ago

Hi, to get my total WIP hours, I tried to use:

Total WIP hours =
CALCULATE(SUM('Tracking Sheet'[Build Hours]),[Powertrain_WIP_Relative]="WIP")

and it spits back "A function 'CALCULATE' has been used in a True/False expression that is used as a table filter expression. This is not allowed."

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    Are you on the latest Power BI Desktop ? I thought that logic limitation had been lifted recently.

    • Whitney's avatar
      Whitney
      Helper II
      5 years ago

      Yes, I believe so