Create a new column

[tuncay]

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 solution]

Hello

You can use following DAX to create column to get result.

Column E or B = IF(LEFT('TableName'[ColumnName], 1) = "E", "It is E", IF(LEFT('TableName'[ColumnName], 1) = "B", "It is B"))