cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## Error Table return text as YES, if not No

1 ACCEPTED SOLUTION
Community Support

According to your description, you first need to change the field type of columnA-E from True/False to Test type, and then try the following formula to get the result.

``````Column =
IF (
'Table'[A] = "True"
|| 'Table'[B] = "True"
|| 'Table'[C] = "True"
|| 'Table'[D] = "True"
|| 'Table'[E] = "True",
"Yes",
"No"
)``````

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 REPLIES 3
Community Support

According to your description, you first need to change the field type of columnA-E from True/False to Test type, and then try the following formula to get the result.

``````Column =
IF (
'Table'[A] = "True"
|| 'Table'[B] = "True"
|| 'Table'[C] = "True"
|| 'Table'[D] = "True"
|| 'Table'[E] = "True",
"Yes",
"No"
)``````

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Frequent Visitor

@amitchandak

One or more "True" text from columns A to E should return "Yes" on the new column, otherwise it will return "No".

Super User

Logic is not very clear

a new column =

if([A] =false() ||[B] =false() || [C] =false() || [D] =false() || [E] =false(), "Yes", "No")