Forum Discussion
JaipalAnu
Helper III
Helper IIINeed 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
mussaenda
Community Champion
Community ChampionHi 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
mussaendaCommunity Champion
Community ChampionThen simply replace the null with ConfigSubtype.
You just need to provide a condition to the RBA so it will not take CAP