Calculated field to show last execution of a report

Questions & Answers
1

Look for help to create a calculated in (usage statistics) account to get the last execution date of specific report.

2

Hi @knayak,
Please try this formula to get the last execution date of a specific report:

TimestampToDate(
  Max(
    Filter([Time].[Day].Members,
    [Measures].[Report Executions]>0
    ),
    DateToTimestamp([Time].CurrentHierarchyMember.StartDate)
  )
)

Don’t forget to change the measure formatting to the date format.

In the report it looks like this:

last_execution_date
last_execution_date1852×1480 344 KB

best,
Gerda // support@eazybi.com

3

Is it possible to embed that date in the report or dashboard description using Markdown? Thanks in advance!