Forum Discussion
Solved
Working days error
I have a report with information on working days up to date and remaining days. In Power BI Desktop, the information shows the correct number of days, but in the published report, with daily updates...
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.
How can i fix it?