Forum Discussion
DAX Add Custom Column, Date Duration minus WeekEnds
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 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.
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
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.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