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

Filter several ranges of values

Hello,

 

Im actually trying to filter my DBase that it´s in an Excel sheet. I have my ID client number that goes from 0 to 999999. Also i has several states. For example Active/ Inactive / etc.

 

I managed to filter the states in Power Query. (Activa=Active) (Padrón= Client ID)

image.png

 

Now I only have to stay with the following ranges:

Id Number from

>=0 <=14999

>=16000 <=199999

>=950000 <= 959999

 

I tried using this filter but it didn´t work

image.png

 

Thank!!!

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Filter several ranges of values

@palvarez8 you can manually add or condition to filter, here in following example I have two condition

 

1- between 100 and 110

2 - between 500 and 600

 

you can add more OR conditions to meet your range requirement.

 

image.png






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





View solution in original post

2 REPLIES 2
Highlighted
Super User
Super User

Re: Filter several ranges of values

@palvarez8 you can manually add or condition to filter, here in following example I have two condition

 

1- between 100 and 110

2 - between 500 and 600

 

you can add more OR conditions to meet your range requirement.

 

image.png






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





View solution in original post

palvarez8 Frequent Visitor
Frequent Visitor

Re: Filter several ranges of values


@parry2k wrote:

@palvarez8you can manually add or condition to filter, here in following example I have two condition

 

1- between 100 and 110

2 - between 500 and 600

 

you can add more OR conditions to meet your range requirement.

 

image.png


Thank! it worked. What if i want to create a measure with that conditions? What DAX formula should I use?

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 273 members 2,855 guests
Please welcome our newest community members: