Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

conditionally duplicate column

We have a data set in Excel with customer data. The set has a few columns:   Customer Name Customer Number Customer Group   Each Customer (=each row in the Excel file) has a unique Customer num...
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Anonymous You are missing the final part of the formula

= IF('Combined PDAR'[Connection ID] = BLANK(), 'Combined PDAR'{Entity ID],'Combined PDAR'[Connection ID])

 

essentially you are saying: If the "Connection ID" is blank, use the "Entity ID", otherwise use the "Connection ID"

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Anonymous,

= IF('Combined PDAR'[Connection ID] = BLANK(), 'Combined PDAR'{Entity ID],'Combined PDAR'[Connection ID])

In addition, also change "{" to "[" in the formula.:smileyhappy:

=
IF (
    'Combined PDAR'[Connection ID] = BLANK (),
    'Combined PDAR'[Entity ID],
    'Combined PDAR'[Connection ID]
)

 

Regards