I originally posted an issue I was having and I was recommended to use a certain function to correct for UTC once the report is posted to the cloud service.
I then experimented with various functions and found that these date function created through custom columns would not update or refresh automatically or forced. But when I created a relative date, using a new column calculation, the date does refresh.
I believe this is a bug. These are the following steps I took:
1) New Column:
Now = Now()
UTCNow = Now() - 0.16666667
2) Edit Query - Add Column – Custom Column:
UTCToday = DateTimeZone.SwitchZone(DateTimeZone.FixedLocalNow(), -4)
Today = DateTime.LocalNow()
3) Time on PBI Desktop (see images)
4) Posted Time on PBI Cloud before midnight
5) Refreshed Time on PBI Cloud after midnight