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
v-xulin-mstf's avatar
v-xulin-mstf
Icon for Community Support rankCommunity Support
5 years ago

Hi Whitney,

 

Try measure as: 

Total WIP hours = 
sumx(filter('Table',[Powertrain_WIP_Relative]="WIP")),'Tracking Sheet'[Build Hours])

 

Best Regards,
Link

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Whitney's avatar
Whitney
Icon for Helper II rankHelper II
5 years ago

v-xulin-mstf thanks, this worked for the first calculation however, I'm now getting this error for the WIP forecast:


'an invalid numeric representation of a date value was encountered'

Total WIP Forecast =
IF(ISBLANK([Total WIP Hours]),
CALCULATE([Total WIP Hours],SAMEPERIODLASTYEAR('IDW DimDate'[Date])),
BLANK() )
 
however, my Date is a date value
  • v-xulin-mstf's avatar
    v-xulin-mstf
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Whitney,

     

    Please check:

    Does your date column contain an irregular date format? For example 'Year 9999'.

    If the issue persists, you can abandon the time-intelligent function and use the time function instead.

     

    Best Regards,
    Link

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

    • Whitney's avatar
      Whitney
      Icon for Helper II rankHelper II
      5 years ago

      HI v-xulin-mstf 

      See below - issue still persists. Time intelligence was ticked however, unticked still results in the same error.

      • v-xulin-mstf's avatar
        v-xulin-mstf
        Icon for Community Support rankCommunity Support
        5 years ago

        Hi Whitney,

         

        Try measure as:

        Total WIP Forecast =
IF(ISBLANK([Total WIP Hours]),
CALCULATE([Total WIP Hours],DATEADD('IDW DimDate'[Date],-1,YEAR)),
BLANK() )

         

        Best Regards,
        Link

         

        If this post helps then please consider Accept it as the solution to help the other members find it more quickly.