Complex Issue in Power BI using =NetworkDays()

Hi All,

I am novice in Power BI but loving the learning journey. I have come across a problem I am not sure how to approach.

Problem
I have 4 start dates and 4 end dates (see below table):

Start Date Column

Team 1 Start

Team 2 Start

Team 3 Start

Team 4 Start

End Date Column

Team 1 End

Team 2 End

Team 3 End

Team 4 End

I want a new column that will do the following (using =Networkdays):

• Find which column has Start Date (e.g. [Team 2 Start] contains the date)
• THEN
• See if the corresponding End Date is also captured ([Team 2 End])
• If End Date exists - calculate # of Network days between the 2 dates
• ELSE
• Use Today() as the End Date
• Calculate # of network days between the 2 dates (with 2nd date being Today())

I have been able to work out how to do this between 2 specified date columns but unsure how to get it find which column contains a start date and then it's corresponding end date column.
This is what I am using to achieve that:

=NETWORKDAYS([Team 1 Start Date],IF([Team 1 End Date]= BLANK(),TODAY(),[Team 1 End Date]))

Apologies if I haven't been clear. Would really appreciate the guidance.

Thank you.