Forum Discussion
Alta88
Helper IV
Helper IVShowing Top 3 Records from 2 Groups
How do I display the top 3 records of these project IDs from two general project size groups (Large vs. Small)? Project Size Group ID Large 1 Large 8 Large 25 Large 77 Larg...
ryan_mayu
Super User
Super Useryou can try to add a new column in pq
= Table.AddColumn(#"Changed Type1","Rank",each Table.RowCount(Table.SelectRows(#"Changed Type1",(x)=>x[Project Size Group]=[Project Size Group] and x[ID]>[ID]))+1)
then you can filter the new column to get top3