cancel
Showing results for
Did you mean:
Helper V

## If a cell contains true then 1

Hello Dear Community,

I have a question.

I have a table like that :

 L1 L2 L3 Result expected True True True 1 True True False 1 True False True 1 True False False 1 False False True 1 False True True 1 False False False 0

If he is one true on column then 1

If only false then 0

Can you help me please ?

Thank you.

1 ACCEPTED SOLUTION
Super User

Are they text values or Boolean True/False?

Do you want to do this in Power Query or DAX?

try this in Power Query assuming the column is text

``if [L1] = "False" and  [L2] = "False" and  [L3] = "False" then 0 else 1``

In DAX create this calculated column assumgin the column is True/False (Boolean)

``Column = IF ([L1] = FALSE() && [L2] = FALSE() && [L3] = FALSE(), 0, 1)``

If the columns are text then use this DAX

``Column = IF ( CONTAINSSTRING('Table_Text'[L1], "False") && CONTAINSSTRING('Table_Text'[L2], "False") && CONTAINSSTRING('Table_Text'[L3], "False"), 0, 1)``

Regards

Phil

If I helped you, click on the Thumbs Up to give Kudos.

Proud to be a Super User!

3 REPLIES 3
Super User

Hi Milozebre,

This calculated column should work:

``````Result =
SWITCH (
TRUE (),
'Table'[L1] = TRUE ()
|| 'Table'[L2] = TRUE ()
|| 'Table'[L3] = TRUE (), 1,
0
)``````

Best regards,

Tim

Proud to be a Super User!

Super User

Are they text values or Boolean True/False?

Do you want to do this in Power Query or DAX?

try this in Power Query assuming the column is text

``if [L1] = "False" and  [L2] = "False" and  [L3] = "False" then 0 else 1``

In DAX create this calculated column assumgin the column is True/False (Boolean)

``Column = IF ([L1] = FALSE() && [L2] = FALSE() && [L3] = FALSE(), 0, 1)``

If the columns are text then use this DAX

``Column = IF ( CONTAINSSTRING('Table_Text'[L1], "False") && CONTAINSSTRING('Table_Text'[L2], "False") && CONTAINSSTRING('Table_Text'[L3], "False"), 0, 1)``

Regards

Phil

If I helped you, click on the Thumbs Up to give Kudos.

Proud to be a Super User!

Helper V

Hello @PhilipTreacy

Thank you for the solution, its works 🙂

Announcements

#### 2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.