Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |