https://github.com/jairofortunato/PowerBIproject
Dataset containing Sales & Profits of a Superstore
The preprocessing was to be made in Power Query and Excel but the columns with number values always come with problems, the data type is text value and when imported all the “.” disappear, so SQL was used to transform the data before importing to Power BI:
UPDATE samplesuperstore
SET Sales = ROUND(Sales, 2);
UPDATE samplesuperstore
SET Profit = ROUND(Profit, 2);
When exporting the data we change the data types but Power Query still change values from this:
To this:
To get the decimal numbers i can just divide by 100 but some values have less or more characters making the formula not the same for every value**.**
The solution was to change the points to commas but first we change the data type because we cant change UPDATE characters in INT data type:
ALTER TABLE samplesuperstore MODIFY COLUMN Sales VARCHAR(10) NOT NULL,
MODIFY Discount VARCHAR(10) NOT NULL,
MODIFY Profit VARCHAR(10)NOT NULL;