Peter Djuandi Posted February 5, 2019 Share Posted February 5, 2019 Hi, I have a data set as shown and I want to show onlythe rows with latest date. How do I do that Name Date aaa 2/13/2017 aaa 4/23/2011 aaa 6/30/1998 bbb 1/2/2011 bbb 3/25/2019 ccc 2/5/2017 ddd 3/11/2000 ddd 7/28/1998 ddd 10/29/1996 Result: Name Date aaa 2/13/2017 bbb 3/25/2019 ccc 2/5/2017 ddd 3/11/2000 Thank you. Link to comment Share on other sites More sharing options...
Gaia Paolini Posted February 7, 2019 Share Posted February 7, 2019 hi create a calculated column, say called isMaxDate: [Date]=Max([Date]) OVER ([Name]) then filter data with isMaxDate=True Gaia 1 Link to comment Share on other sites More sharing options...
Peter Djuandi Posted February 7, 2019 Author Share Posted February 7, 2019 Thanks Gaia. This method adds a colum with each row/Name filled with the latest date. This could be an option. I found another option using ranking in the show/hide properties : Rank(RowId(),"asc",[Axis.Value])=1 which only shows the row/name that has the latest date. Link to comment Share on other sites More sharing options...
Gaia Paolini Posted February 7, 2019 Share Posted February 7, 2019 you can use [Date]=Max([Date] OVER ([Name]) too as a limiting expression Gaia Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now