Forum Discussion

MrMilk's avatar
MrMilk
Helper I
2 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

    7-17Date day of week.pbix48 KB
MrMilk's avatar
MrMilk
Helper I
2 years ago

my timezone is UTC