PowerBI Assignment 3

Sudeepta Pritam Apr 06 2021 · 1 min read
Share this

The initial data set was  as given below :

Richest person in the world

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.

Transformed dataset.

Visual to show that net worth column is treated as numbers.

Table showing individual net worth and summation for each country the top 9 richest person belong
Read next