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
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.
Solved! Go to 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
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
@Disaster110 I Hope this helps you.
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
95 | |
86 | |
78 | |
66 |
User | Count |
---|---|
151 | |
121 | |
111 | |
107 | |
95 |