Filter top top 3 values

[Anonymous]

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 

[Zubair_Muhammad · Accepted solution]

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)