Adding set hours to make up for UTC time difference

[DaZzz]

First time poster so hopefully I'm doing this right.

I currently have a visual filter that filters by week. However, I'm 12 hours ahead of UTC, so on Mondays, this filter does not update until around 12 p.m. my time. I don't want to change my powerBI locale as I have already way too much set up, rather I just want to add 12 hours to this filter so it turns over early (or as soon as there is data to be filtered).

This is the WeekFilter DAX I'm using to display each week: Week_Filter = Calender1[Date]-WEEKDAY(Calender1[Date],2)+1

I've tried +time(12,0,0), I've tried adding a day or two, I've confirmed there is data to be displayed on next week's filter.

WeekFilter VisualVisual SettingsCalender1 Table

[FreemanZ]

hi @DaZzz ,

not sure if i fully get you, you may do it via a calculated column like:

Column = [DateTime]+0.5

it worked like:

or you do it via Power Query, to add a column like:

=[DateTime]+#duration(0,12,0,0)