Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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
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
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |