Forum Discussion

Dave403's avatar
Dave403
Frequent Visitor
6 years ago
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 be...
  • Anonymous's avatar
    Anonymous
    6 years ago

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

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

 

 

  • Dave403's avatar
    Dave403
    Frequent Visitor
    6 years ago

    Hi Pranit 

     

    Works perfectly, thanks for the help.

     

    Dave