6 Replies Latest reply on Sep 21, 2017 7:31 AM by Neil Lord

    How to display the latest date in a Dashboard Title without filtering

    Michael Feigin

      I have a large number of rows with data and each one of them has a date stamp.

      I want my dashboard title to include the following "Data through <latest date in the data>" where the latest date will be pulled and updated automatically as the data gets refreshed.

       

      I have created a measure as follows: WINDOW_MAX(MAX([Date])), however, cannot make it show in the dashboard as a text.

       

      Here is a data mock-up:

      Customer
      DateSales
      A1/1/201716345
      B5/30/20173654646
      A6/30/2017145665
      B6/30/2017546564

       

      Please help.