Forum Discussion

paw1's avatar
paw1
Icon for Helper I rankHelper I
3 years ago
Solved

Last refresh data in local time zone

Hi,   I have added Last Refresh Date like below in Power BI Dashboard. But the requirement is users want to see the Last Refresh date in there local timezone. Please help me to solve this.   ...
Need Help
  • Arul's avatar
    Arul
    3 years ago

    paw1 ,

    try to create this measure and use.

    Last Refreshed Date/Time = 
MAX('Last Refreshed Date'[Last Refreshed date])+5.5/24

    Thanks,

    Arul

     

Arul's avatar
Arul
Icon for Super User rankSuper User
3 years ago

paw1 ,

Can you give one example of what you are exactly expecting?

Thanks,

Arul

  • paw1's avatar
    paw1
    Icon for Helper I rankHelper I
    3 years ago

    Hi Arul 

    I am looking for how to show above refresh data in local Asia time in power bi report. Currently its showing in london time.

    • Arul's avatar
      Arul
      Icon for Super User rankSuper User
      3 years ago

      paw1 ,

      try to create this measure and use.

      Last Refreshed Date/Time = 
MAX('Last Refreshed Date'[Last Refreshed date])+5.5/24

      Thanks,

      Arul