Hello,
I have a table where new entries are recorded, the user inputs the values for the columns Criteria 1, Criteria 2 and Criteria 3.
For Column Output, I am looking for an expression where based in the user input, it will look up for the desire output based on the references in another table:
Solved! Go to Solution.
Thank you Steve, I tried this expression but its working:
ANY(SELECT(Tables Reference[Output],AND([Criteria 1]=Tables Reference[Criteria 1],[Criteria 2]=Tables Reference[Criteria 2],[Criteria 3]=Tables Reference[Criteria 3])))
User | Count |
---|---|
26 | |
25 | |
25 | |
20 | |
19 |