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

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
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