Gantt Reworked with ADDCOLUMNS, FILTER, GENERATE and SUMMARIZE

At the end of my last post in the Gantt Chart series, GANTT CHART WITH RESOURCE LOADING, I said that I would return to explain how the Hours measure worked. I took a brief diversion, almost foray, into the world of CRM PIPELINE FUNNEL CHARTS but I'm now back to explain the workings of that Hours measure. You can revisit PART1 and PART2 of this series to recap.

In the interim, I've been working on some "fine tuning" of that Hours measure. I'll come onto the final solution in due course, but I'll work through the workings of the Hours measure as we left it initially to explain why it needed tuning up!