Forum Discussion
power query
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.
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.
1 Reply
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.