Splitting and pivoting comma separated column

Hi all,

After playing around with both Power Query and Dax functions, I can officially say that I'm stuck. 

I have a column in my table that looks like this:

I want to both split by delimeter and pivot the columns so that my table looks like this:

Here is what I have tried:

1. Power Query -

• Split column by the comma delimeter 

  Project	Complexity Counts 1.1	Complexity Counts 1.2
  1	Simple (2)	Medium (1)
  2	Medium (5)	null
  3	Large (1)	Simple (1)
  4	Mini (.5)	null
  5	Mini (1)	Medium (3)

• Split each of these new columns by the "(" and then remove the extra ")"

  Project	Complexity Counts 1.1	Complexity Counts 1.1.1	Complexity Counts 1.2	Complexity Counts 1.2.1
  1	Simple	2	Medium	1
  2	Medium	5	null	null
  3	Large	1	Simple	1
  4	Mini	.5	null	null
  5	Mini	1	Medium	3

• Pivot "Complexity Counts 1.1" into Complexity Counts 1.1.1

• Project	Simple	Medium	Large	Mini	Complexity Counts 1.2	Complexity Counts 1.2.1
  1	2	1	null	null	Medium	1
  2	null	5	null	null	null	null
  3	1	null	1	null	Simple	1
  4	null	null	null	.5	null	null
  5	null	3	null	1	Medium	3

Issues with this:

1. When I try to pivot "Complexity Counts 1.2" I get an error that columns "Medium" and "Simple" already exist. I would like for this to pivot these numbers into the existing columns but clearly it doesn't work like that.
2. I don't know how many Complexities are going to be in each column. While the example I show only has 1-2 complexities per project, they might have more. So I would have to do this power query forumla on an unknown number of columns after separating by the comma delimeter.

Dax:

• I tried in Dax just creating a custom column for each complexity type, like
  • Medium = IF(CONTAINSSTRING('Project Tracker'[Complexity Counts], "Medium"), True, False)
• Issues with this:
  • I cannot figure out how to get the actual count instead of just True or False. A column with "Medium (2), Simple (1)", should return a 2.
  • New complexities arise all the time. They may not always be Mini, Simple, Medium, and Large. So I would have to go in and create a new column anytime a new complexity shows up in the spreadsheet.