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 Yes if the Sign (from Table 1) is - rather then <. Current and Desired results shown in table 1, so the 2nd row should be No. Please can anyone help?
Column = IF(RELATED('Table 1'[Value])>'Table 2'[Threshold],"Yes","No")
| Parameter code | Value | Sign | Current result | Desired result |
| A | 5 | - | Yes | Yes |
| A | 5 | < | Yes | No |
| Parameter code | Threshold |
| A | 3 |
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.
2 Replies
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.
