Forum Discussion

Whitney's avatar
Whitney
Icon for Helper II rankHelper 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
Icon for Super User rankSuper User
5 years ago

Would you mind mentioning the errors you are experiencing?

  • Whitney's avatar
    Whitney
    Icon for Helper II rankHelper 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
      Icon for Super User rankSuper 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
        Icon for Helper II rankHelper II
        5 years ago

        Yes, I believe so