How to create formula-based columns in Power BI for forecasting?

Hello,

I have a somewhat unique table sitting in an excel file and I'm unsure how exactly to rewrite it in Power BI. Essentially, I have multiple projects in my rows, a date by which the project's capacity should be filled, and columns showing me months from today in which the project fill rate is evenly distributed by month until the start date of that project. 

Currently, my month columns are based on 'today()' for the first column with 5/12 and then using EDATE to add 1 month and I've manually stretch my columns to the end of 2022. I then have two sets of IF statements to tell me the months that a project is eligible to be "Sell" status and then another similar table to bring in the capacity that needs to be filled in remaining months.

This table is used to forecast the necessary totals by month that need to be filled as time passes forward. I'm guessing the most 'manual' solution would be to hard code column names and merely use them as references. I appreciate any help!