cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
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.





2 REPLIES 2
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.





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
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.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 258 members 3,192 guests
Please welcome our newest community members: