Ravi Sir's Cards › Excel
Fixing Power Query errors: NA, types, duplicates
Revision card: Fixing Power Query errors: NA, types, duplicates. Example data table with Couldn't convert to Number: NA: no error; Which number type for 1.5?: Decimal Number; order_id 101 appears twice: 3 rows remain.
Read card text
What this card says
Fixing Power Query errors: NA, types, duplicates
Example
data table with Couldn't convert to Number: NA: no error; Which number type for 1.5?: Decimal Number; order_id 101 appears twice: 3 rows remain
Learn this in the lesson: Power Query: Fix DataFormat.Error with NA, US Dates (M/D/YYYY) with Locale, Decimal Sales and Duplicate Rows vs Keys