Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Showing last refreshed date that user pushed the refresh button

Hi gurus, I have a question in regards to my situation: I have a report consisting of 10 gauges. My report has several dim and fact tables. One of the tables gets refreshed by user pushing refresh ...
  • Anonymous's avatar
    Anonymous
    7 years ago

    The Problem solved by using the

    #table(type table[Last Refresh=datetime], {{DateTime.LocalNow()}})

    and adding a custom column in my facts table which works with

    = Table. AddColumn(#Added Custom1, "Date", each DateTime.Date([LocalRefreshDate]), Type Date)