This repository provides Power Query M codes for essential data modeling day-to-day tasks. Power Query is a powerful data transformation and cleansing tool that helps to prepare and clean data for analysis. The M codes in this repository can be used to add new rows to dimension tables, change column names to proper case, remove ugly characters, and flag columns with certain letter values. These codes can save time and effort for anyone working with Power Query to model and prepare data for analysis.