How to find rows associated with latest date value

Hello! I've tried my hand at a number of solutions offered in the forums for similar topics but haven't succeeded - mostly because I'm extremely new to DAX/Powerquery/M. Basically, I have a table...

Need Help

v-juanli-msft
7 years ago
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