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.
Hey MrMilk
Here are few thing you need to check
1)Check Timezone Settings - Ensure the timezone settings on your machine (where Power BI Desktop is running) and on the Power BI Service are synchronized
2)Data Refresh Scheduling - Schedule your data refresh in Power BI Service to happen at an appropriate time.
3) Clear Browser Cache - Sometimes clearing the browser cache can resolve display issues.
4) Check Gateway Settings - Verify the system time and timezone where the gateway is installed.
Thank you