Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to Forecasting working hours for current month?

Hello    I am trying to forecast working hours for each employer for the current month (The rest of the month (Nov. 03- Nov. 30). I have data from the beginning of this year. Can anybody please hel...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    The picture is vague, please forgive if the word is misspelled. 

     

    Try this measure. TODAY function returns the current date.

    Forecast =
CALCULATE (
    SUM ( 'Table'[rc_hrs] ),
    FILTER (
        'Table',
        [timeslip_date] <= DATE ( 2020, 11, 30 )
            && [timeslip_date] > TODAY ()
    )
)

     

     

    Best Regards,

    Stephen Tao

     

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

cabal's avatar
cabal
New Member
5 years ago

Hi Anonymous ,

 

You can do it in another way (by graph): use line chart with forecast analysis. By this way, you will be able to get a forecast line with a trusty limits.