Forum Discussion

Applicable88's avatar
Applicable88
Impactful Individual
5 years ago
Solved

PowerBi server weekday vs. local weekday

Hello,   I need a function to return the day number of the real local time. My offset to the server are two hours. I use this for my calculated column which shows me the number of today. I created ...
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Applicable88 

     

    Not sure if I understand it correctly, so you want to know the weekday of server time and it is fixed 2 hours lagging, like this?

     

    Date.DayOfWeek((DateTime.FixedLocalNow()- #duration(0,2,0,0)), Day.Sunday)