Forum Discussion

New2PowerBI's avatar
New2PowerBI
Helper III
9 years ago
Solved

Help with Text Comparison Formula

I have one table; with "VIN" numbers, one called Serial#(Audra List) and the other called VIN NUMBER (Maximo List). 

 

I added a new column with the following:

 

Comparison = if(VehicleComparison_ChristieDent[Serial# (Audra List)] = VehicleComparison_ChristieDent[VIN NUMBER (Maximo List)], 1, 0)

 

Everything came back "0" but I know there is at least one row where the values that did not match.  I don't understand why my formula isn't working.

 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    My only guess would be some leading/trailing spaces that need to be trimmed out.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    My only guess would be some leading/trailing spaces that need to be trimmed out.

    • New2PowerBI's avatar
      New2PowerBI
      Helper III
      9 years ago

      Disregard my last one; did a quick look up on trimming data and trimmed both columns, worked!!  Thanks!!

    • New2PowerBI's avatar
      New2PowerBI
      Helper III
      9 years ago

      ?  I've not dealt with that before; how can I trim the data?