topic Re: Forecast of the end of hours based on recent consumption in DAX Commands and Tips

Forecast of the end of hours based on recent consumption

josegracaaxians — Wed, 26 Jun 2024 09:18:07 GMT

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!

Re: Forecast of the end of hours based on recent consumption

Anonymous — Thu, 27 Jun 2024 02:23:51 GMT

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.

Re: Forecast of the end of hours based on recent consumption

josegracaaxians — Thu, 27 Jun 2024 10:10:15 GMT

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