Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Last Refresh Date - Alternative Solution

I am currentyl using the following DAX sattement to calculate a time stamp for Last Refresh:   = DateTime.Time(DateTime.LocalNow()) & DateTime.Date(DateTime.LocalNow())   Increasingly, I need a s...
Need Help
Show and Tell
  • RMDNA's avatar
    RMDNA
    8 years ago

    Hi Anonymous,

     

    I've found this to be useful when I'm designing reports for worldwide customers. Rather than dealing with general timezones and DST/etc., just pull data related to the location itself.

     

    Query:

     

    let

        Source = Web.Page(Web.Contents("http://localtimes.info/Asia/Saudi_Arabia/Riyadh/")),

        Data1 = Source{1}[Data],

        #"Changed Type" = Table.TransformColumnTypes(Data1,{{"Column1", type text}, {"Column2", type text}}),

        date = #"Changed Type"{1}[Column2],

        time=#"Changed Type"{0}[Column2],

        datetime=DateTime.FromText(date&" "&time)

    in

        datetime

     

     

    Output example:

     

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

RMDNA

 

I did this.  Same result.  Perhaps the format of the query needs to be changed?

 

RMDNA's avatar
RMDNA
Solution Sage
8 years ago

I followed my steps exactly as above in a blank PBIX and I've attached it for you to download. Without more details, I can't figure out what's going wrong on your end.

 

The other option would be for you to share your PBIX, but I'm guessing this would be a security risk.

 

Example PBIX download

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    RMDNA

     

    Thanks!  I was able to put it together.  I think my steps were slightly out of sequence.  Will this "stamp" stay static until the data is refreshed?

     

     

    • RMDNA's avatar
      RMDNA
      Solution Sage
      8 years ago

      Yes - it's treated as a table, so it will refresh with the rest of the report unless told not to.