Forum Discussion

azaterol's avatar
azaterol
Icon for Helper V rankHelper 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] ), 

azaterol's avatar
azaterol
Icon for Helper V rankHelper V
4 years ago

tamerj1  works fantastic! Can you explain how this work? 

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

azaterol 

It is just exactly as you read it. If the NR is in the supplier ID table then 20000000000 otherwise 10000000000 then add this number to the numeric value id table1[ID]