Forum Discussion

ahmadi1364's avatar
ahmadi1364
New Member
2 years ago
Solved

create category product with base column product code

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

 

@measure
  • Anonymous's avatar
    Anonymous
    2 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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