How to Use the Query Function to Clean and Combine Data for Power BI

In this post, I share how I used the query function to clean and prepare three csv files of sales data from different years. I learned how to rename, choose, filter, observe, add, mix, substitute, and verify data in the query editor. I also created a new table with all the three years combined. This helped me import the data to Power BI and create some amazing visualizations and insights. I hope you enjoy this post and learn something new!