Forum Discussion
How to find rows associated with latest date value
Hi itspossible
From the screenshot, it seems unique "post id" associated with each unique instance of "message", so i use "post id" as a test.
create a new table from your table
Table = FILTER(ALL(Table1),[date]=CALCULATE(MAX(Table1[date]),ALLEXCEPT(Table1,Table1[post id])))
Original table
New created table
Best Regards
Maggie
Helper IYou can create a new table with the SUMMARIZE function. You get a table with unique posts with a MAX date. So you will have the maximum DB_DATE per post.
Create a new table under the tab modeling and enter the following code:
POST_WITH_MAX_DATE = SUMMARIZE(Sheet1; Sheet1[type]; Sheet1[post_id]; "Total Value"; max(Sheet1[db_date]))
Hi there, while the code provided works perfectly for those 3 columns referenced in it, it fails its intended purpose when I add the other columns into the query - particularly shares_count, comments_count, likes_count and reactions_total_count. I am back to seeing multiple entries for post_id. How can I fix this?
So close to a solution. Anyone have any suggestions?
bump