Forum Discussion

NISH72's avatar
NISH72
Helper IV
6 years ago
Solved

Conditional calculated column

Hi all I have the following table Id.     Name 1.       A 1.        B 2.        C 3.        D 4.        E   If a particular Id has multiple names attached to it.( For eg id 1 has two names at...
Need Help
Show and Tell
  • camargos88's avatar
    camargos88
    6 years ago

    Hi NISH72 ,

     

    Try this code for a new column:

    NewColumn =
    VAR _result = CALCULATE(COUNT('Table'[Id]); ALLEXCEPT('Table'; 'Table'[Id]))
    RETURN IF(_result > 1; 1; 0)
     
camargos88's avatar
camargos88
Community Champion
6 years ago

Hi NISH72 ,

 

Try this code for a new column:

NewColumn =
VAR _result = CALCULATE(COUNT('Table'[Id]); ALLEXCEPT('Table'; 'Table'[Id]))
RETURN IF(_result > 1; 1; 0)
 
NISH72's avatar
NISH72
Helper IV
6 years ago

When I add this formula in the new column it's throwing syntax error. It's not accepting return if function. Thank you