Need help with DateTime field

Hi Experts,

In my report, I have multiple date fields. This date is coming from SQL server which are saved in US timezone. After publishing the report, this report will be consumed by users from different world locations. What I want is that, the users should be able to see all the dates as per their local timezone. (Like people from India should see the date in his local timezone and people from Australia should see date in his local timezone)

I tried using DateTimeZone DAX function but cannot just stick to for single time zone calculation, as the user can be at any location, so he should see date in his timezone.

Can anyone guide me how to acheive this use case?

Regards,

Kushal