If formula

[Rockiz]

Hi, I am trying below formula in custom column in power query but its showing error, please help on this
if(and([is_blkd_for_secondary_costs_posting]="x",[is_blocked_for_commitment_posting]="x",[is_blocked_for_plan_primary_costs]="x",[is_blocked_for_plan_revenues]="x",[is_blocked_for_plan_secondary_costs]="x",[is_blocked_for_revenue_posting]="x",[is_blkd_for_primary_costs_posting]="x",[consumption_qty_is_recorded]=x),"lock",
"active")

[SachinNandanwar · Accepted solution]

I think instead of commas you need to replace them with and

[SachinNandanwar · Accepted solution]

Does it work ?

[Anonymous · Accepted solution]

Hi @Rockiz 

Here is another approach:

if List.MatchesAll({[Column1],[Column2],[Column3],[Column4]}, each _ = "x") then "lock" else "active"

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

[Rockiz]

Thanks it worked

[Anonymous · Accepted solution]

Hi @Rockiz 

Here is another approach:

if List.MatchesAll({[Column1],[Column2],[Column3],[Column4]}, each _ = "x") then "lock" else "active"

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

[Chewdata · Accepted solution]

Also a good approach, but this will only work under the condition that "x" is the same value across all columns.

[Chewdata]

if

[is_blkd_for_secondary_costs_posting]="x" and

[is_blocked_for_commitment_posting]="x" and

[is_blocked_for_plan_primary_costs]="x" and

[is_blocked_for_plan_revenues]="x" and

[is_blocked_for_plan_secondary_costs]="x" and

[is_blocked_for_revenue_posting]="x" and

[is_blkd_for_primary_costs_posting]="x" and

[consumption_qty_is_recorded]=x

then

"lock"

else

"active"

[SachinNandanwar · Accepted solution]

Does it work ?

[SachinNandanwar · Accepted solution]

I think instead of commas you need to replace them with and