power query

[Enkei]

Hello,

I am taking hundreds of rows of values from a csv file. But I only want values of rows between some specific column values. 

For example I want values from Age 1 to 13. Remaining rows I want to remove. 

[StefanoGrimaldi · Accepted solution]

hey, 

you have different ways, if this its a constant value that will be no changin on the right blank square of the column click it and put a filter by number iqual or greater tham "value" , equal or less them "value", 

if not you can also do this setting parameters on the filters value on the power query M code to change it on the report by parameters. 

if this helped give some kudos and mark as solution for others to find.