Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

New column using three other columns - Two being blank

Hi,   I am trying to add a new column (Reporting Qty TO) which returns the value from Quoted Qty where the other two columns are BLANK, however in this same new column (Reporting Qty TO) if there i...
Need Help
  • johnt75's avatar
    johnt75
    1 year ago

    You can create a calculated column like

    Reporting Qty TO =
COALESCE (
    'Table'[Reporting Qty RTU],
    'Table'[Reporting Qty Sample],
    'Table'[Quoted Qty]
)

    The order you put the columns in matters - it will use the first non-blank value it finds, so in this example if Reporting Qty RTU has a value then it will use that. Only if that column is blank will it check Reporting Qty Sample.

johnt75's avatar
johnt75
Icon for Super User rankSuper User
1 year ago

You can create a calculated column like

Reporting Qty TO =
COALESCE (
    'Table'[Reporting Qty RTU],
    'Table'[Reporting Qty Sample],
    'Table'[Quoted Qty]
)

The order you put the columns in matters - it will use the first non-blank value it finds, so in this example if Reporting Qty RTU has a value then it will use that. Only if that column is blank will it check Reporting Qty Sample.