Forum Discussion

Anonymous

Not applicable

7 years ago

Solved

Last loading date display

Hi everyone,

My report is almost complete but I still have a question :

I would like to display the date of recording (from my database (Oracle), once a month).

Is it possible to make a parameter or something ?

And the same for the loading of my Excel files, I tried but I can't do it.

If someone could give me some ideas ?

Thanks by advance,

Have a nice day !!

Anonymous
7 years ago
go to Get data --> Blank Query
Goto Advanced Editor

Delete everything in there and replace it with this:

let
Source = #table(type table[LastRefresh=datetime], {{DateTime.LocalNow()}})
in
Source

This will give you a date and time everytime the report refreshes

3 Replies

Anonymous
Not applicable
7 years ago
go to Get data --> Blank Query
Goto Advanced Editor

Delete everything in there and replace it with this:

let
Source = #table(type table[LastRefresh=datetime], {{DateTime.LocalNow()}})
in
Source

This will give you a date and time everytime the report refreshes
- Anonymous
  Not applicable
  7 years ago
  Hi ! Thanks so much Anonymous !
  
  It's working
  but I don't know how to put it on my report
  it's blank even if i've got the right information in my data
  Thanks by advance,
  
  Have a nice day !
  - Anonymous
    Not applicable
    7 years ago
    Ok, I just find the solution, I created a new measure
    LastRefreshDate = FORMAT(LASTDATE('Refresh'[LastRefresh]); "dd mmmm yyyy, hh:mm:ss")
    and it's working ! :smileyvery-happy: