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.
I found the problem... In the calendar table, I use the formula Date.DayOfWeek([Date]) to determine the day of the week, considering that 0 is Sunday. In Power BI Desktop it assumes this way, but in the published report it is different...0 is monday
how can i fix it? anyone with this issue?
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.