Forum Discussion

azaterol's avatar
azaterol
Helper V
4 years ago
Solved

Fill with digits

Hello everyone, I have a table "Customers_and_Suppliers" that contains an ID and the corresponding Customers_and_Suppliers_NR. I want to add a  custom column in this table. If there is a NR that mat...
Need Help
  • tamerj1's avatar
    tamerj1
    4 years ago

    Ho azaterol 

    you can try

    IF ( Table1[Customers_and_Suppliers_NR] IN VALUES ( Supplier[ID], 20000000000, 10000000000  ) + VALUE ( Table1[ID] ), 

Hoangechip910's avatar
Hoangechip910
Frequent Visitor
4 years ago

Hi

Try the calculate column below

 

Adress ID = if( Customer_and_Suppliers_NR in {"10","20","30","40","50"},2000000000 + VALUE(ID),1000000000 + VALUE(ID))

 

or

 

Adress ID = if( Customer_and_Suppliers_NR in {"10","20","30","40","50"},
                         REPLACE ("2000000000",10- LEN(ID) + 1,LEN(ID),ID coummn),

                           REPLACE ("1000000000",10- LEN(ID) + 1,LEN(ID),ID coummn) )