Forum Discussion

adnankabina's avatar
adnankabina
Helper II
5 years ago
Solved

Refresh time on visual

I want to show Estern time on my visual. I have schedule for every 2 hours to refresh my data.  what I did on measure Last Refreshed Time = UTCNOW()-TIME(4,0,0) It is showing fine but it should s...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi adnankabina ,

     

    In your scenario, you should use Calculated Column or M Query instead of Measure.

    The former will refresh time after the dataset was refreshed, the latter will refresh time after the page was refreshed.

    For calculated column, right click on the table and create a new column using your formula.

    For M Query, open query editor and add custom column with below formula.

    DateTime.LocalNow() + #duration(0,4,0,0)

     

    Best Regards,

    Jay

  • adnankabina's avatar
    adnankabina
    Helper II
    5 years ago

    Thanks for help. After publishing it is showing me UTC time , how can i subtract 4 hours? any idea

    • AnkitKukreja's avatar
      AnkitKukreja
      Super User
      5 years ago

      Hi adnankabina 

       

      Yes, please use DateTime.From ( [DateTime] ) + #duration(0, +5,0,0)

      Note : +5 is utc to my time zone (so change as per your need). And [DateTime] is my date time column already availbale.

       

       

      Thanks,

      Ankit

      • adnankabina's avatar
        adnankabina
        Helper II
        5 years ago

        Hi AnkitKukreja,

         

        Should I do in blank query or create a measure. I didnt get you.

         

        This is what I did in blank query but go error.

        = DateTime.From ( [DateTime] ) + #duration(0, +5,0,0)

         

        Expression.Error: There is an unknown identifier. Did you use the [field] shorthand for a _[field] outside of an 'each' expression?