Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Parameter code | Value | Sign | Current result | Desired result |
A | 5 | - | Yes | Yes |
A | 5 | < | Yes | No |
Parameter code | Threshold |
A | 3 |
Solved! Go to Solution.
Hi @tgjones43 ,
Try the DAX formula stated below whether it works for you.
Hi @tgjones43 ,
Try the DAX formula stated below whether it works for you.
User | Count |
---|---|
94 | |
86 | |
78 | |
70 | |
63 |
User | Count |
---|---|
114 | |
101 | |
97 | |
66 | |
59 |