Chapter 3 : Data Transformation - The Query Editor
Chapter 3 : Data Transformation - The Query Editor

Chapter 3 : Data Transformation - The Query Editor

image

https://xlncad.com/power-query-editor/

4. Changing Data types:

5. Replacing values

6. Connecting data to CSV

7. Connecting data to website

8. Extract character

9. Split column

10. Extract character Vs Split column

11. Merge column

12. Creating conditional columns

13. Creating Columns from Examples

14. Merging Queries (Adding columns as new)

15. Pivoting & Unpivoting in Power BI

16. Append Queries: Adding Rows