"Exclude" LOD expression Provides Different Results with DATEPART vs datepart
Published: 19 Nov 2018
Last Modified Date: 12 Dec 2018
IssueExclude LOD expression displays different results in the view depending on whether DATEPART or datepart is used in the calculation.
An example can be seen in the attached sample workbook.
ResolutionAs a workaround, perform one of the following options:
- Use upper case function (DATEPART) to get the correct result.
- Use the same format (uppercase or lowercase) in LOD expression and dimensions in the view.
Tableau performs case sensitive string comparison when determining what fields to exclude as part of an EXCLUDE LOD calculation.