Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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??
Solved! Go to Solution.
Make it
#"Filtered Rows"
Hence, following will work
= Table.SelectRows(#"Filtered Rows", each [PymtDatePeriodNum] = List.Max(#"Filtered Rows"[PymtDatePeriodNum]))
Make it
#"Filtered Rows"
Hence, following will work
= Table.SelectRows(#"Filtered Rows", each [PymtDatePeriodNum] = List.Max(#"Filtered Rows"[PymtDatePeriodNum]))