The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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")
Solved! Go to Solution.
I think instead of commas you need to replace them with and
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.
Thanks it worked
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.
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"
I think instead of commas you need to replace them with and