8 Replies Latest reply on Oct 8, 2018 4:30 AM by Aditya K

    Filtering Records in Tableau using Conditions

    Aditya K

      Hello Everyone,

           I have a problem where I have to filter the records with the latest EffDate for every ID. For example, in the sample data which I have attached, for ID = 1, I want only the records from 05-Oct-2018 and for ID = 2, records from 02-Oct-2018 and so on. Effectively, What I want is the latest records by ID and EffDate. In Tableau, how do i achieve this? Please help. Thanks.