create category product with base column product code

[ahmadi1364]

hi friends 

i want to write a measure for create  local/export  category product using the product code 

for example :

 product code  start with  number 1 = local sales

product code start with number 2 = export

[Anonymous · Accepted solution]

Hi  @ahmadi1364 ,

Here are the steps you can follow：

1. Create calculated column.

Test =
IF(
   VALUE( LEFT('Table'[product code],1))=1,"local sales",
 IF(
       VALUE(LEFT('Table'[product code],1))=2,"export",BLANK()))

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly