Forum Discussion

martin_waller's avatar
martin_waller
New Member
9 years ago

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

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.

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    9 years ago

    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

     

     

     

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    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