Create a new column

Question

I want to create a new column, which inspects another column and if the cell contents starts with E, the new column should be: It is E. If it's B, it should be: It is B. And so on. How can I create such a column?

anonymous · Accepted Answer

HelloYou can use following DAX to create column to get result.&nbsp;Column E or B = IF(LEFT('TableName'[ColumnName], 1) = "E", "It is E", IF(LEFT('TableName'[ColumnName], 1) = "B", "It is B"))

Forum Discussion

Create a new column

1 Reply

Related content

Create columns group

Creating a date column

Creating a custom column

unpivoting columns and creating datetime column

Appending columns and creating new column of old column headers