Power Query: Add Column

The Add Column tab in Power Query is where you enrich your dataset by creating new columns based on existing data. Instead of modifying an existing column, this tab allows you to add calculated, conditional, or extracted data as a new field. It's a key step in data preparation, enabling you to derive new insights and build a more complete dataset for analysis.

Power Query: Mastering Date and Time in "From Date & Time" Section

Dates and times are the backbone of almost every dataset. From analyzing sales trends to tracking project deadlines, your ability to work with temporal data is a key skill for any data professional. Yet, raw date columns can be messy and hard to analyze. Manually extracting years, months, or quarters is a tedious and error-prone process.

Power Query: Add Column

Fakhriddinbek

5 hours ago3 min read

Spreadsheet showing GDP data and forecasts for various countries. Highlighted menus show options for text transformation actions.

Power Query: Data Cleaning with a Comprehensive Guide for From Text section of Add Column

While many of Power Query's features are designed for structural changes, the Power Query: Data Cleaning with a Comprehensive Guide for From Text section of Add Column and its counterparts are where you do the detailed work of standardizing and correcting your data at a granular level. This guide will walk you through the essential transformations for text, numbers, and dates, showing you how to turn your messy raw data into a clean, trustworthy dataset ready for analysis.

Power Query: Add Column

Fakhriddinbek

5 hours ago4 min read