Use Field Data as Operator

Question

I want have the operator used in a custom column be based on the data in another field but keep getting an error.&nbsp;For example, my dataset has the following fieldsField A (The DataPoint)&nbsp; &nbsp; &nbsp;Field B (The Measurement Type)&nbsp; &nbsp; &nbsp;Field C- (The Threshold)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp;I want to write a custom column formula that says:If [Field A] [Field B] [Field C] then 1 else 0&nbsp;The formula works if i type in &gt; instead of using [Field B], however, some rows use another operator (like = or &lt;). Is there a way to write the formula with the operator being [Field B]?&nbsp;

mikelytics · Accepted Answer

Hi&nbsp;hatcher78&nbsp;&nbsp;But I have another idea how you can to it:&nbsp;Measure =
SWITCH(
   SELECTEDVALUE([FieldB]),
   "&gt;", IF([FieldA]&gt;[FieldC],1,0),
   "&lt;", IF([FieldA]&lt;[FieldC],1,0),
   "&gt;=", IF([FieldA]&gt;=[FieldC],1,0),
   "&lt;=", IF([FieldA]&lt;=[FieldC],1,0)
)&nbsp;Best regardsMichael-----------------------------------------------------If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Appreciate your thumbs up!@ me in replies or I'll lose your thread.

Forum Discussion

Use Field Data as Operator

2 Replies

Related content

Power BI Error: DM_GWPipeline_Gateway_SpooledOperationMissing – Gateway Data Operation Issue

Build - Data field weird behavior

SQL Operator with multiple destinations

Use Wildcard Operator

Arithmetic Operation Overflow