Query that returns a list that fall inside th eminimum & maximum figures

[martin_waller]

I have a list of equipment that have Min and Max figures for performance charateristics. These are seperate colums in an excel table. I want to be able to use the query function to be "ask" which pieces of equipment have a perofrmance figure of 12.7 i.e. show me a list of equipment where 12.7 is between the min and max figure?

I am runnning out of ideas.

[v-huizhn-msft]

Hi @martin_waller,

Have you resolved your problem? If you have not, please share some more details and sample data for further analysis. 

Thanks,
Angelia

[Greg_Deckler]

Specific are going to depend on your data but if you had a table with values, 12.7, etc. you could use that in a slicer. Let's say that this table and column are Table and Value respectively. Let's also say that you have a table called Equipment with columns Name, Min and Max. Create a measure like:

Measure = IF(MAX(Table[Value])>MAX(Equipment([Min]) && MAX(Table[Value])<MAX(Equipment([Max]),1,0)

Create a table with your Name in it and filter the visual to where Measure = 1