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

 

Tell me what I am doing wrong.  

 

1.  Select Edit Queries

2.  New Source

3.  Blank Query

4.  Advanced Editor

5.  Cut/Paste Query as written in the note

 

And then the card just displays the query?

 

 

RMDNA's avatar
RMDNA
Solution Sage
8 years ago

No, the card will display the data pulled from the code I gave you, which is the date/time info for whatever city is chosen. See below.

 

So the code I gave was for Riyadh, in Saudi Arabia, so you'll need to change the URL to whatever city is appropriate for you. After that, follow the steps you've listed and you should see the date/time as a new query in the Query Editor.

 

 

After that, if you close and apply the changes, the query will show up in your usual Field pane, and the value can be added to a card:

 

  • 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?

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi,

      I follow your given all steps but card not show as date/time format. 

       

      1. Select Edit Queries

      2.  New Source

      3.  Blank Query

      4.  Advanced Editor

      5.  Cut/Paste Query as written in the note

       

      And then the card just displays the query? please tell me how to resolve

       

      dt.JPG

       

       

    • 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?