Forum Discussion

Regular Visitor

4 years ago

Solved

Measure - Append 2 Columns

How do I append 2 columns by a measure or by creating a new calc. column?

you can try this

sumofcallforecast = sum('Table'[calls forecasted])

sumofcalloffer = sum('Table'[calls offer])

measure = if(ISBLANK('Table'[sumofcallforecast]),'Table'[sumofcalloffer],[sumofcallforecast])

1 Reply

Super User

you can try this

sumofcallforecast = sum('Table'[calls forecasted])

sumofcalloffer = sum('Table'[calls offer])

measure = if(ISBLANK('Table'[sumofcallforecast]),'Table'[sumofcalloffer],[sumofcallforecast])