Forum Discussion
If formula
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")
I think instead of commas you need to replace them with and
Does it work ?
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!Also a good approach, but this will only work under the condition that "x" is the same value across all columns.
6 Replies
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"
Does it work ?
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!Also a good approach, but this will only work under the condition that "x" is the same value across all columns.
I think instead of commas you need to replace them with and
Thanks it worked
