Networks days between different tasks/Filters

[Disaster110]

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 to find the networkdays between the [Initiated_Date] of [Task_Code] = "DAPPREASS" and the [Complete_Date] of [Task_Code] = "DAPDEC".
Does anybody know how I can create a measure or calculated column to acheive this please. Have tried multiple filters, measure helpers columns etc. but cant get it to work.
Thanks in advance.

[Disaster110 · Accepted solution]

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

[Mahesh0016]

@Disaster110 I Hope this helps you.

VeloNetWorkDays =

VAR MnDate =      MINX(

                            FILTER(

                                    financials,financials[Product]="Velo"

                                  )

                                ,financials[Date]

                      )

VAR MxDate = CALCULATE(

                        MAXX(

                                FILTER(

                                        financials,financials[Product]="Velo"

                                      )

                                ,financials[Date]

                            )

                      )

RETURN

NETWORKDAYS(

            MnDate,

            MxDate,

            1 // Ignore Saturday and Sunday

)

[TomMartens]

Hey @Disaster110 ,

consider creating a pbix file that contains sample data, but still reflects your data model: tables, relationships, calculated columns and measures. Upload the pbix to onedrive, google drive, or dropbox and share the link. If you are using a spreadsheet to create the sample data instead of the manual input method share the spreadsheet as well.

Do not forget to describe the expected result based on the sample data you provide. Also add data visualizations to a report page and describe how you expect the result is "mapped" to the visual(s).

Regards,

Tom