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...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

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

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?