Complex Issue in Power BI using =NetworkDays()

[Iceshade]

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	End Date Column
Team 1 Start	Team 1 End
Team 2 Start	Team 2 End
Team 3 Start	Team 3 End
Team 4 Start	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.