Relative Day Filtering is calculating based on another time zone.

[Anonymous]

I created a report that provides previous day data, and it works very well, except one issue that I can't seem to figure out.

So, I have my Date filters set to grab previous day data (is in the last 1 day, and unchecked include today). This works great in the mornings, but as the afternoon comes around, it begins grabbing today's data. I know this uses UTC time zone, but I need to have the reports filter based on PST. This also creates issues with the report subscriptions.

How can I have the report keep the correct relative filtering all day? 

[v-yuta-msft · Accepted solution]

Hi shradhara2,

To achieve the localtime which will not be affected with successive calls, you should add an offset in your measure using DAX like below:

Local Time =
NOW () + TIME ( 8, 0, 0 )

Or you can use power query function DateTimeZone.FixedLocalNow to achieve your localtime instead.

Regards,

Jimmy Tao