Forum Discussion

itspossible's avatar
itspossible
Frequent Visitor
7 years ago
Solved

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's avatar
    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

itspossible's avatar
itspossible
Frequent Visitor
7 years ago

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?

itspossible's avatar
itspossible
Frequent Visitor
7 years ago

So close to a solution. Anyone have any suggestions?