Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |