Last Modified Date: 03 Apr 2020
Environment
Tableau DesktopAnswer
The below steps can be reviewed in the attached sample workbook: ShowLastDateWithData.twbx.Step 1 - Check for Null values
- Create a new calculated field.
- Using the measure we want to check for available data enter a formula similar to the following: ISNULL( [Measure] )
- Click OK
Step 2 - Find Last Date
- Create a new calculated field.
- Enter the following formula referencing the above calculation: { FIXED : MAX(IF NOT [Is Sales Null] THEN [Date] END) }
Step 3 - Compare last date against all dates
- Create a new calculated field.
- Enter the following formula: [Date] = [Last Date ]
- Drag this field onto the filters shelf and select True.
Additional Information
See attached workbook for sample of steps above.Discuss this article... Feedback Forum
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials