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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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