5 Replies Latest reply on Apr 15, 2018 11:16 PM by Peter Fakan

    Formula for filtering data connection 10.5

    ChicagoTableauUser

      I need help with a formula that I want to use as a condition for filtering data in the data source.I have a parameter in my workbooks called "Date Selector",

       

      I previously had this formula : [Date] = [Date Selector] which would show me the values in my data as of that reporting period but I have other data I want to include for older data where it is the latest available. I cant just say filter by latest available as I want to be able to use the date selector for older periods if needed and so wouldn't want the latest in that case. Using desktop 10.5.

       

      This is what I am thinking but need help on syntax:

       

      IF [Date] = [Date Selector] OR ([Date] < [Date Selector] AND ([Is Latest],"TRUE")