Forum Discussion
Applicable88
5 years agoImpactful Individual
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 ...
- Anonymous5 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)
Anonymous
5 years agoNot applicable
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)