Forecast of the end of hours based on recent consumption

[josegracaaxians]

Hello Good Morning,

I have the HR data of their work hours, and the contracted hours, and I wanted to forecast based on recent consumption (3 or 6 months)  when the contracted hours will end.

Horas Remanescentes = [Horas Contratadas]-[Horas realizadas]

Horas realizadas = SUM(Eventos[Horas])

Horas Contratadas = 51840 ( Its given)

Thanks for helping!

[Anonymous]

Hi @josegracaaxians ,

You can add a measure like below, I assuming that they work 6 hours a day:

Forecast = 
VAR _WORKDAY = [Horas Remanescentes] / 6
RETURN
    SELECTEDVALUE ( 'Table'[date] ) + _WORKDAY

 Final output:

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

Best Regards,

Ada Wang

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

[josegracaaxians]

What 'm looking for is a measure that, based on recent consumption of hours, show me the hours made and so that I can see where the forecast equals the "Horas contratadas" by perfis ( profile description)

and by area (área):