Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.