Forum Discussion
julsh41
Helper II
Helper IICorrectly Calculating Projected Available Hours between a start and end date
I am trying to figre out the correct measure to show "Projected Hours" for future possible assignments for resources. The Gantt chart works easy enough. It is pulling Start and End date from a s...
TomMartens
Super User
Super UserHey,
please prepare some sample data, exact to the data model, but just some sample data.
Upload the pbix and / or xlsx to onedrive or dropbox, and share the link.
Please, also provide the expected result for one or two resources and their split across months.
Regards,
Tom
julsh41Helper II
Helper IIHi tom
Let me know if this works for you. You should find a pbix and an excel file. The Forecast tab is driving the pbix query. The Expected results tab is how I would expect the results in the pbix to isplay based on Start and End dates in excel file