The initial data set was as given below :
OBJECTIVE : The objective is to remove the $ sign and 'billion' word from the net worth column and convert the data type of the column to whole number. Also create some visual for the same
The $ sign and 'billion' is removed by replace values option in Power query. Both are replcaed by null value
The data type of the column is changed to whole number and below dataset is received.
Visual to show that net worth column is treated as numbers.
