Forum Discussion
Solved
Need help in if and else condition in Query editor
Hello Everyone, I have a field with the Name ConfigType and it has two values "CapEX" & "RBA", so I'm applying one condtion in the Power Query with the IF logic to get the CAP & COR. But the cond...
Then simply replace the null with ConfigSubtype.
You just need to provide a condition to the RBA so it will not take CAP
Hi JaipalAnu ,
it is because of you else in the end.
you should put another condition like if ConfigType is RBA then null else CAP
or
at the end of your statement before else,
you can insert like if ConfigType is Capex then CAP else null
Then simply replace the null with ConfigSubtype.
You just need to provide a condition to the RBA so it will not take CAP