Forum Discussion

PeteD1302's avatar
PeteD1302
Helper I
6 years ago
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...
Need Help
  • PeteD1302's avatar
    PeteD1302
    6 years ago

    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

PeteD1302's avatar
PeteD1302
Helper I
6 years ago

Hi, I was wanting a query editor solution, if possible; this currently gives me a day difference (including weekends) as e.g. 8.6 days, minus weekends would be = 6.6 days.

I did look at the Order_delivery_date_diff tables and the calculation for Way 4 date Diff, this is similar to a calculated column I am already using giving a final result in whole days. My start and end dates are in Date/Time, I was wanting to achieve a day result in part days e.g.; 6.6. My final data table has many rows and I am calcuating an average for a large dataset, so the number of days needs to be accurate in part days.

Thanks