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

v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

Hi, PeteD1302 

 

I'd like to suggest you use datetime data type as the parameters. You need to use List.DateTimes function instead of List.Date.

 

Best Regards

Allan

PeteD1302's avatar
PeteD1302
Helper I
6 years ago

Hi Allan, I did change to Date Time formats. For both Date and Date-Time the result appears to be the same; all full days.
I tried changing to Decimal and display 1 decimal point, both have e.g. 97.0
Attached screen print for the Date-Time below.

 

  • PeteD1302's avatar
    PeteD1302
    Helper I
    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