Do you know that Power Query can clean your data and remove rows that have inaccurate data? If you are not aware of this feature then go through the below steps.
Data Analytics Tricks in Power BI – Guidebook
You too can analyze data like a Data Scientist. No coding needed. No statistics needed.
Analyze & Visualize data using Power BI. (23 tricks in one book)
Let’s take an example. As shown in the below picture there is some revenue that has invalid values. Therefore we want to remove these rows.
Load the data in Query Editor and note the rows that contain the error values. Here, three rows contain error values.
To remove the error rows, follow the below steps:
Click Close & Load from the Home tab to apply the pending changes.
You now have your new data table without any inaccurate rows!
Data Analytics Tricks in Power BI – Guidebook
You too can analyze data like a Data Scientist. No coding needed. No statistics needed.
Analyze & Visualize data using Power BI. (23 tricks in one book)