Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
hola amable comunidad
Requiero de su apoyo para poder sumar 5 dias habiles (no contar sabados ni domingos) a una fecha tipo DateTimezone
Tengo un campo Date con miles de fechas, por ejemplo esta fecha (26/05/2023 6:00:00 PM) al sumar los 5 dias habiles mi fecha de salidad debe ser 02/06/2023 6:00:00 PM
Yo intente con Date.AddDays(#date,5) pero me da error y esta consulta no separa los dias inhabiles.
Esta solucion debe ser en power query por favor, gracias por su amable apoyo.
Hi @FrankGaraco ,
According to your description, if you want to add 5 working days, you can directly add 7 days to the original date, as each 7 days will includes 5 working days.
Best regards,
Community Support Team_yanjiang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.