Forum Discussion

Jays_D's avatar
Jays_D
Advocate II
3 years ago

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):   ...
Need Help
v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
3 years ago

Hi Jays_D ,

According to your description, I create a sample to reproduce:

Here's my solution, create a calculated column.

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

Get the result:

I attach my sample below for your reference.

 

Best regards,

Community Support Team_yanjiang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.