Forum Discussion
some_analyst
Helper I
Helper IChanging when 'Today' starts on the server
I have a slicer which shows me the date: Formatted Date Full =
VAR SelectedDate = dim_date[PK_date]
RETURN
IF(
SelectedDate = TODAY(),
"Today",
CONCATENATE(
CONCATENATE(dim_dat...
Hi some_analyst
Use UTCNOW() instead of TODAY() to reflect the current UTC time. Note that UTCTODAY() always returns the UTC datetime at 12:00 AM, regardless of the actual time of day in UTC. Also, you can simply the date format to just FORMAT(SelectedDate, "dddd, dd/mm/yyyy") instead of using CONCATENATE.
sevenhills
Super User
Super UserCould you try displaying what is the value you are getting for these using DAX and PQ:
Say,
NZ Date = NOW() + (12/24)
NZ Date2 = TODAY() + (12/24)
PW 1 = DateTimeZone.SwitchZone(DateTimeZone.LocalNow(),12,0)