Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I'd like to create a column similiar to this Excel-column in Advanced Query Editor:
CP REAL =IF([@[CP Raw]]>30;IF(H6368<=20;30;CA6368);CA6368)
The conditional column only allows me to create if X Then Y Else Q statements. But i'd like to create a
IF THEN IF ELSE ELSE statement.
How do I do this in Advanced Query Editor? Please note that, for various reasons, I don't want to create this column after i've applied my data to my report.
Solved! Go to Solution.
Hi @Anonymous
Please see the below
Regards,
Mariusz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If something>x then do something else (if somethingdifferent then whatever else theend)
Hi @MattAllington & @Mariusz
Thanks for your reply! Almost there. But what I want him to do is basically this:
So skip the first THEN and go straight into the else "if" statement.
Hi @Anonymous
Wouldn't the below give you a desired outcome?
Regards,
Mariusz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi not really.
Basically what it says is: When BARGE_CP_RAW is greater than 30, use BARGE_CP_RAW, but not if TotalMoves is less then 20. Then use "30".
Your suggestion says: When BARGE_CP_RAW greater than 30 and TotalMoves is less than 20, then 30.
Hi @Anonymous
Please see the below
Regards,
Mariusz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
Please see the below.
Regards,
Mariusz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |