Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Disaster110
Helper I
Helper I

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 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.

 

1 ACCEPTED SOLUTION
Disaster110
Helper I
Helper I

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



View solution in original post

3 REPLIES 3
Disaster110
Helper I
Helper I

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
Super User
Super User

@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
Super User
Super User

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



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.