Forum Discussion

Disaster110's avatar
Disaster110
Helper I
2 years ago
Solved

Networks days between different tasks/Filters

Hi All, Another NETWORKDAYS problem that I need help with please. I have a table 'Application_Tasks' with the following columns of interest [Task_Code], [Initiated_Date], [Complete_Date]. I need t...
  • Disaster110's avatar
    2 years ago

    Thanks For your help team.
    I got there in the end with this solution - 
    1. 

    Decision stage = SUMX(

        FILTER(

            'infodbo Application_Tasks',

            'infodbo Application_Tasks'[Task_Code] = "DAPDEC"

        ),

        NETWORKDAYS(

            'infodbo Application_Tasks'[Initiated Date],

            'infodbo Application_Tasks'[Complete Date],

            DAY

            7

        )

    )

    Pre-assessment time = SUMX(

        FILTER(

            'infodbo Application_Tasks',

            'infodbo Application_Tasks'[Task_Code] = "DAPPREASS"

        ),

        NETWORKDAYS(

            'infodbo Application_Tasks'[Initiated Date],

            'infodbo Application_Tasks'[Complete Date],

            DAY

            7

        )

    )  
    PMD to Decision date = 'Measures table' [Pre-assessment time] + 'Measures table' [Decision stage]
    Giving me the total work days from Pre-assessment task start to Decision stage finish.
    Tim H