Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I have query on Time zone isuue.
I have adate column of Created_Date with UTC time. With respective to user I need to convert UTC to their time zone in the report.
(Ex: A client has multiple Users wit different time zones. A User need to see date column as their local time zone. UTC + 5.30 timestamp)
Plz share ur ideas on this and DAX queries for this
Thanks
Solved! Go to Solution.
Here is a measure expression that will dynamically change a UTC datetime to the local datetime. You could use a similar approach in a DAX column, but the user would have to refresh the pbix file for it to recalculate.
Here is a measure expression that will dynamically change a UTC datetime to the local datetime. You could use a similar approach in a DAX column, but the user would have to refresh the pbix file for it to recalculate.
Assuming you know where the User lives by a country column, I would create another dimension table listing down all countries in one column and their respective difference from UTC zone (in hours) in anoter column. Create a custom column in fact table, use the related value from that dimension table to add/subtract from the UTC time stamp. Name that column Local time or something and use that column where relevant.
It might affect your refresh time since it's data transformation, but because there's no DAX involved, the runtime will be fast.