DAX Time Zone Issue in Power BI
Power BI is a cloud service, and that means Power BI files are hosted somewhere. Some DAX functions such as Date/Time functions work on system date/time on the server their file is hosted on. So If you use DAX functions such as TODAY() or NOW() you will not get your local date/time, You will fetch server’s date/time. In this lesson I’ll explain methods of solving this issue, so you could use Power BI to resolve your specific time zone’s date and time.