Forum Discussion
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 condition is added only for CapEX but not for RBA.
As per the logic when i use ConfigType and ConfigSubType in same slicer, It is showing Cap & COR for both Capex and RBA. It should show only for Capex not for RBA. The logic is below.
Please help
ConfigSbTYpe = if[ConfigType] = "CapEx" and [L1 Grouping]="AMI" then "CAP"
else if [ConfigType] = "CapEx" and [L2 Grouping]="AGR" then "COR"
else if [ConfigType] = "CapEx" and [L3 Grouping]="AGR" then "COR"
else "CAP"
The CAP & COR should show only for Capex not for RBA, Please help.
parry2k , des PPRO , Microsoft
Then simply replace the null with ConfigSubtype.
You just need to provide a condition to the RBA so it will not take CAP
3 Replies
Then simply replace the null with ConfigSubtype.
You just need to provide a condition to the RBA so it will not take CAP
