How to convert date values to local timezone

[Gokulg]

Hi,

I have a Power BI account in IST timezone, the same account have access to CRM. So the date field value in CRM and Power BI report is same (Importing data). The same record is accessed from another account from CST timezone, so there in CRM the date value is one day less but the Power BI report is deployed in services and added in CRM using the first account (IST timezone account). Here the date is not converting to CST timezone when CST user access the report.

Please help to convert the date value based on local timezone (if IST account is accessed the date value should display IST timezone and if CST account is accessed the date should display CST timezone value)

Thanks,

Gokul

[Fowmy]

@Gokulg 

Have you looked at this article from Reza?

https://radacad.com/showing-current-time-and-latest-refresh-time-at-local-timezones-in-the-power-bi-...

https://radacad.com/solving-dax-time-zone-issue-in-power-bi