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
Check this file having datediff excluding weekend
https://www.dropbox.com/s/y47ah38sr157l7t/Order_delivery_date_diff.pbix?dl=0
Appreciate your Kudos.
Hi,
for those readers who don't have that additional column:
I just published a NETWORKDAY-function here that doesn't even require that additional column: https://www.thebiccountant.com/2020/02/20/date-networkdays-function-for-power-query-and-power-bi/