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 Allan (Microsoft), Are you able to attach a sample scenario pbix file, so I can see where I am going wrong.
I followed your instrucions exactly, and cannot see why I am getting an error.
Thanks Peter

  • PeteD1302's avatar
    PeteD1302
    Helper I
    6 years ago

    Hi Alan (at Microsoft), Thanks for the sample file, that helped a lot, one step closer to a solution.
    I have tested with 2 sets of date formatted data, one with Date [works OK], the other with Date/Time; this one has an error message.
    I really need my result in part days, not whole days.
    Do you have any suggestions.

    • 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.