Last Modified Date: 09 Jul 2018
Environment
- Tableau Desktop 9.3.6
- Windows 7
- Excel
Answer
Add the [date] filter to context.
Then, the following calculation will find the value of [field of interest] associated with the most recent [date] value for each [ID].
{FIXED [ID] :
MAX (
IF [date] = {FIXED [ID] : MAX ( [date] ) } THEN [field of interest] END
)
}
Additional Information
{FIXED} Level of Detail Expressions ignore Dimension Filters. Therefore, the [date] filter must be added to context.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