none
Power Bi Filter lines of a table RRS feed

  • Question

  • Hi,

    I want to add a filter which take the 20 most recent "status" for each "tcversion_id" 

    Here is the column of my table

    i got the date of the tests, with his status and the id of the tests and i would like to take the 20 most recent status for each id.

    Thanks

    Thursday, April 25, 2019 11:53 AM

Answers

  • Hi LitSin,

    This code should work:

    let
        group = Table.Group(YourTable, {"tcversion_id"}, {"temp", each Table.FirstN(Table.Sort(_, {"execution_ts", 1}),20)}),
        temp = Table.Combine(group[temp])
    in
        temp
    • Marked as answer by LitSin Friday, April 26, 2019 8:06 AM
    Thursday, April 25, 2019 2:47 PM