Select rows with max pay period

[Anonymous]

Trying to select the rows with the greatest value in Pay Period column.  I want all deductions for the latest period in this d365 table.

Getting an error on this statement:

= Table.SelectRows("Filtered Rows", each [PymtDatePeriodNum] = List.Max("Filtered Rows"[PymtDatePeriodNum]))

(Error:  "We cannot convert the value "Filtered Rows" to type Table.")

Ideas??

[Vijay_A_Verma · Accepted solution]

Make it

#"Filtered Rows"

Hence, following will work

= Table.SelectRows(#"Filtered Rows", each [PymtDatePeriodNum] = List.Max(#"Filtered Rows"[PymtDatePeriodNum]))