Forum Discussion
Solved
Adding extra condition to IF function with RELATED
Hi all I am using the following DAX formula to check whether a value in Table 1 exceeds a set threshold, given in Table 2. This works fine, but I want to include an additional step to only say Ye...
Hi tgjones43 ,
Try the DAX formula stated below whether it works for you.
Column =IF('Table 1'[Sign] = "-",IF('Table 1'[Value] > LOOKUPVALUE('Table 2'[Threshold], 'Table 2'[Parameter code], 'Table 1'[Parameter code]),"Yes","No"),"No")The above one checks for the "-" sign. If it is, it checks if the value in Table 1 is greater than the threshold value in Table 2 that matches the parameter code in Table 1. If it is, then returns "Yes", otherwise it returns "No". If the sign in Table 1 is not "-", it returns "No".Hope this might help you.
Hi tgjones43 ,
Try the DAX formula stated below whether it works for you.
Column =
IF(
'Table 1'[Sign] = "-",
IF(
'Table 1'[Value] > LOOKUPVALUE('Table 2'[Threshold], 'Table 2'[Parameter code], 'Table 1'[Parameter code]),
"Yes",
"No"
),
"No"
)
The above one checks for the "-" sign. If it is, it checks if the value in Table 1 is greater than the threshold value in Table 2 that matches the parameter code in Table 1. If it is, then returns "Yes", otherwise it returns "No". If the sign in Table 1 is not "-", it returns "No".
Hope this might help you.
