Power BI Dynamic column quantity and Name

Hi Kalyj, 

The intent of this dashboard is resource managment for labor and create a Capacity vs. Demand visual. My table I pull from has Dates in the first row, Projects down the first column and assigned number of staff assigned to each project each day. My date spread is every working day for 4 years so to make it usable in PowerBI, I transpose it, then promote the headers.

So with this table, I will Transpose it, Promote the headers as normal. Then I need to do a Change Type step. Normally when performing this step, each column would be refrenced by the name of the header, which is fine if the data headers never change.

Now the issue I am having is, when I add a project to my list or projects are completed and remove from the table, referencing the header text will break the code ( {"A", type number},). Example a week goes by and project "A" is completed and I add projects "G" and "F" my table will now look like below image. (Keeping completed projects is not realistic as my real data would contain thousands of projects, this is only an example. )

And I will get the following error as expected.

To work through the header issue by referencing the column number vs. column name. This fixes the issue that "A" is no longer the header.

The next issue I incounter is increase/decrease in projects. If my project qty increases, the added columns don't change type. If the project qty decreses, the code breaks as there is not enough columns in the data set to complete the code.  

I hope this explains my situation much better and how to try and manage Dynamic names and column qty. I assume it would reference everything as a table that can grow and shrink in qty but the first column is always Date type, the rest are Number type. This is where I am stuck.