Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Rockiz
New Member

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")

4 ACCEPTED SOLUTIONS
SachinNandanwar
Super User
Super User

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



Regards,
Sachin
Check out my Blog

View solution in original post

Does it work ?



Regards,
Sachin
Check out my Blog

View solution in original post

Anonymous
Not applicable

Hi @Rockiz 

 

Here is another approach:

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

vjingzhanmsft_0-1722411211034.png

 

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

View solution in original post

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

View solution in original post

6 REPLIES 6
Rockiz
New Member

Thanks it worked

Anonymous
Not applicable

Hi @Rockiz 

 

Here is another approach:

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

vjingzhanmsft_0-1722411211034.png

 

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.

Chewdata
Super User
Super User


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 ?



Regards,
Sachin
Check out my Blog
SachinNandanwar
Super User
Super User

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



Regards,
Sachin
Check out my Blog

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors