DAX - Goal direction stored in field trying to get Column Value to work as operator in if statement

[AZvick]

I am trying to evaluate if a metric meets its goal.  Wether i need to use > or < depends on the goal.  Some positive is good some negative are good.

I am storing the "direction" in a column value  '>='  Tbl[Direction]

I want to use that column value as the operator in an if statement

trend = 

if(

tbl[column A ]

>=  --I want to use Tbl[direction] here as the operator

tbl[column b],"positive', "Negative'

)

Can anyone help?  I just get a generic The syntax is incorrect

[v-jianboli-msft · Accepted solution]

Hi @AZvick ,

Based on your description, I have created a simple sample:

Please try:

trend = 
SWITCH(TRUE(),
[direction]=">="&&[column A]>=[column b],"Positive",
[direction]="<="&&[column A]<=[column b],"Positive",
[direction]=">"&&[column A]>[column b],"Positive",
[direction]="<"&&[column A]<[column b],"Positive",
[direction]="="&&[column A]=[column b],"Positive",
"Negative")

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.