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

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 110 members 1,545 guests
Please welcome our newest community members: