Forum Discussion
Solved
Formula help, create new column with values from 2 columns
Hi Everyone.
Not really sure how to explain this properly, but I am trying to figure out a way to calculate all rows with one result based on the values in 2 other columns. Here is my example below.
So if any of the order numbers have a TRUE from my if statmenent I would like the new column to carry that true into all rows for that order number.
| Order | Work True | Desired result |
| 10 | TRUE | TRUE |
| 10 | TRUE | TRUE |
| 10 | FALSE | TRUE |
| 20 | FALSE | FALSE |
| 20 | FALSE | FALSE |
| 20 | FALSE | FALSE |
| 30 | FALSE | TRUE |
| 30 | FALSE | TRUE |
| 30 | TRUE | TRUE |
Thanks
Hi Dave403
Desired result = if(CALCULATE(COUNT(Table_2[Work True]),ALLEXCEPT(Table_2,Table_2[Order]), Table_2[Work True] = "TRUE")>=1,"TRUE","FALSE")
