Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Filter top top 3 values

Hi everyone, I have week number and sales amount column i have to load only latest 3 week data into power bi. below is the preview of my data. i have to filter for weeks 6,5,4 and if week 7 is added ...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    5 years ago

    Hi Anonymous 

     

    Try adding this step

     

    = Table.SelectRows(#"Sorted Rows", each
    let list=List.Min(List.FirstN(List.Sort(List.Distinct(#"Sorted Rows"[Week Num]),Order.Descending),3))
    in
     [Week Num] >= list)
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
5 years ago

Hi Anonymous 

 

Try adding this step

 

= Table.SelectRows(#"Sorted Rows", each
    let list=List.Min(List.FirstN(List.Sort(List.Distinct(#"Sorted Rows"[Week Num]),Order.Descending),3))
    in
     [Week Num] >= list)