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 use this to get the date for mu calendar table:
let
P_Today = DateTime.LocalNow(),
in my computer is ok, if i publish is ok but on the next day on the daily update becames wrong
As you are using personal gateway maybe the Power Bi desktop report is not up to date when you perform daily update.
as you said after publishing report values are matching but next day it is not matching after refresh.