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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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