Forum Discussion
Working days error
Hi MrMilk ,
Based on the description, try to use the following formula.
Date.DayOfWeek([Date], Day.Sunday)You can also view the following documents to learn more information.
Date.DayOfWeek - PowerQuery M | Microsoft Learn
WEEKDAY function (DAX) - DAX | Microsoft Learn
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi MrMilk ,
Based on the description, the power bi desktop calculate the local time. But, power bi service will return UTC time. Perhaps this is causing the one day short.
Try to add the new column to calculate working days.
Viewing the following documents to learn more information.
Solved: Time Zone issue after publishing report - Microsoft Fabric Community
Solved: DateTime in Published Report shows as UTC - Microsoft Fabric Community
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.