Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
81 | |
76 | |
62 | |
60 | |
48 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |