Forum Discussion
Filter out top 3 rows based on same timestamp
Hello, Im new to power bi, and would be very grateful if someone could help me out. I have table with 3 columns timestamp, procedure, average_cpu. Everytime when data gets generated its ...
Do a Group By on the timestamp column with a new column that keeps all rows for each separate time stamp.
This will generate a step with code that looks like this:
= Table.Group(#"Changed Type", {"timestamp"}, {{"Top3", each _, type table}})We want to modify this slightly using Table.MaxN:
= Table.Group(#"Changed Type", {"timestamp"}, {{"Top3", each Table.MaxN(_, "avergae_cpu", 3), type table}})All that's left is to expand the new Top3 table column by clicking the expand button in the top right corner and pick which columns you want.
AlexisOlson
Super User
Super UserDo a Group By on the timestamp column with a new column that keeps all rows for each separate time stamp.
This will generate a step with code that looks like this:
= Table.Group(#"Changed Type", {"timestamp"}, {{"Top3", each _, type table}})
We want to modify this slightly using Table.MaxN:
= Table.Group(#"Changed Type", {"timestamp"}, {{"Top3", each Table.MaxN(_, "avergae_cpu", 3), type table}})
All that's left is to expand the new Top3 table column by clicking the expand button in the top right corner and pick which columns you want.