Forum Discussion

JaipalAnu's avatar
JaipalAnu
Icon for Helper III rankHelper III
2 years ago
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...
Need Help
Show and Tell
Tips and Tricks
  • mussaenda's avatar
    mussaenda
    2 years ago

    Then simply replace the null with ConfigSubtype.

    You just need to provide a condition to the RBA so it will not take CAP

     

     

JaipalAnu's avatar
JaipalAnu
Icon for Helper III rankHelper III
2 years ago

Thanks for you reply mussaenda 
If i give condition like if ConfigType is RBA then null else CAP

So, here I'm loosing RBA value also, i should not loose that, RBA has to show but in the dropdown CAP has to not show for RBA.