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
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