Create a column with Condition.

Question

Hello,&nbsp;I have a column with Product numbers that are as follows 6500N,76MR1,9ES00A and from these i would derive the Product Type as if the Product Number start with '65' then the Product Type is a,if starts with '76' then B and if starts with '9' then C.How do i do this the easiest way

anonymous · Accepted Answer

In the PowerQuery window, you could click on the Add Column tab in the ribbon and choose a conditional column.&nbsp;&nbsp;&nbsp;

Forum Discussion

Create a column with Condition.

2 Replies

Related content

Create measure to return value from column when condition met for two other columns

Create conditional index column

Create columns group

Conditional Column with Multiple Conditions

Create Conditional Column Based Upon Two Other Columns