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 the i have filter for weeks 7,6,5. how can i active it in power query dynamically.  

 

 

 

Below is the screenshot to how i need data 

 

 

 

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)

1 Reply

  • 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)