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 help me or give me an idea of how to do it.? 
 
I am trying to tell the employer is going to hit the required hours (Each employer has required hour).
 

 

Thank you
 
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.

8 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi, thank you. I want it a tabular table. 

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Icon for Administrator rankAdministrator
      3 years ago

      Hello community! Any examples of how to show overtime in 2023?

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      I think this should work. Let me try this. Thanks 

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thank you so much for your help. 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

    Could you tell me if your problem has been solved?
    If it is, kindly Accept it as the solution. More people will benefit from it.
    Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.


    Best Regards,
    Stephen Tao