Forum Discussion
Solved
DAX Add Custom Column, Date Duration minus WeekEnds
I have a DAX column in my table as follows; = Table.AddColumn(#"Inserted Merged Column1", "Project Cycle Time", each Duration.TotalDays ([DateCompleted] - [DateStart])) I have a Date table that co...
Note that I have managed to find a solution from a previous post; NETWORKDAYS in PowerQuery Editor [Super User IV, Mariusz], from the downloaded example file; duration with no weekends and holidays.pbix
community.powerbi.com/t5/Power-Query/NETWORKDAYS-in-PowerQuery-Editor/td-p/940950
Hi, PeteD1302
Based on your description, I'd like to suggest you refer to the following thread. You may manage to do it step by step.
How to calculate net working days - Step by Step
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.