cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Filtrar en PowerQuery

Buenos días,

 

Quería consultaros si saben como aplicar un filtro en un campo fecha sin añadirlo al modelo de datos como una columna adicional, sería como aplicar un filtro sin añadir la columna que deseo filtrar de fecha.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Solution Sage
Solution Sage

Re: Filtrar en PowerQuery

As you are in Power Query, filter that column and then choose "Quitar" option to remove that column. Once saved, users should not see the column, but filter will work. On the right part of screen you can see steps and last step is removing the column - you can always remove that step if you need that column in future.
Based on screenshot, it seems date is string data type ('ABC'), if you had date column with date data type (calendar icon) you would have dynamic options for filtering date column.

View solution in original post

6 REPLIES 6
Highlighted
Solution Sage
Solution Sage

Re: Filtrar en PowerQuery

Hi @jesuslogmein ,
My spain is not that good, here is the answer in english 🙂
In Power Query you can filter date column on great range of options which are dynamic (like relative filters on slicer): exact date, before/after exact date, between exact days, but also dynamic filters like: last N days, months, years...

Here is screenshot:

date filter power query.PNG

Cheers,
Nemanja 

Highlighted
Frequent Visitor

Re: Filtrar en PowerQuery

thanks Nandic, i did it but my problem is diferent, i need filtered without show a colum. For example:

 

In power query (data model)

 DATE : I need filter by date, select 1 to 20 july but i have dates from 1 to 30 of july.

When I close my data model, in excel, I won´t show colum DATE (we ve other colums.

Highlighted
Solution Sage
Solution Sage

Re: Filtrar en PowerQuery

@jesuslogmein ,
If you are using Power BI, you can import that date column, create a filter as on image on previous mail and then remove the column - filter will remain as you are doing this in Power Query which saves all steps.
Alternative is to hide column on modelling view so that users can't see it.
If you are using Power Query in Excel, you can also add filter on Date column and then you can hide column. When you create pivot table based on that model, column will not be shown, but filter will remain.

If none of these help, please share screenshots of your project (current view and how you would like it to display).

Highlighted
Frequent Visitor

Re: Filtrar en PowerQuery

Hi, I use power query in excel. I haven´t hide option, we have the followings opt (in spanish hide is "Ocultar")

jesuslogmein_0-1595923648542.png

 

Highlighted
Solution Sage
Solution Sage

Re: Filtrar en PowerQuery

As you are in Power Query, filter that column and then choose "Quitar" option to remove that column. Once saved, users should not see the column, but filter will work. On the right part of screen you can see steps and last step is removing the column - you can always remove that step if you need that column in future.
Based on screenshot, it seems date is string data type ('ABC'), if you had date column with date data type (calendar icon) you would have dynamic options for filtering date column.

View solution in original post

Highlighted
Frequent Visitor

Re: Filtrar en PowerQuery

ok!!!! thanks!!!!!

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors