Forum Discussion

paw1's avatar
paw1
Helper 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.

 

 

Thanks in advance.

 

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

     

3 Replies

  • Arul's avatar
    Arul
    Super User
    3 years ago

    paw1 ,

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

    Thanks,

    Arul

    • paw1's avatar
      paw1
      Helper 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
        Super 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