Skip to content
OmidBI Logo – Expert in Power Query, Excel, and Business Intelligence Solutions

OmidBI

  • By Difficulty
    • ⭐️ Beginner
    • ⭐️⭐️ Easy
    • ⭐️⭐️⭐️ Intermediate
    • ⭐️⭐️⭐️⭐️ Advanced
    • ⭐️⭐️⭐️⭐️⭐️Expert
    • ⭐️⭐️⭐️⭐️⭐️⭐️Complex
  • By Topic
    • Advanced Mathematics Problem
    • Aggregation & Summarization
    • Column Splitting
    • Column Transformation
    • Custom Grouping
    • Data Cleaning
    • Data Transformation
    • Date & Time Handling
    • Financial Problems
    • Indexing & Ranking
    • Merging & Joining
    • Missing Values
    • Pivot & Unpivot
    • Text Processing
  • By Creator
    • Omid Challenges
    • ExcelBI Excel Challenges
    • ExcelBI Power Query Challenges
    • Crispo Challenges
  • By Software
    • DAX Challenges
    • Excel Challenges
    • Excel VBA Challenges
    • Google Sheets Challenges
    • Office Script Challenges
    • Power Query Challenges
    • Python Challenges
    • R Challenges
    • SQL Challenges
  • Books
    • 96 Common Challenges in Power Query
Home » General Tags » Power Query » M Functions » M Table Functions » Table.AddColumn

Table.AddColumn

Adds a new column to a table with computed values in Power Query.

Repeat Non-Consecutive Characters
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Repeat Non-Consecutive Characters

Challenge No. 694: Repeat every character in the string except those characters which appear consecutively.
Solved using: R.

February 12, 2026July 21, 2025
Assign Rank1 and Rank2
Posted in
  • ExcelBI Excel Challenges
  • Indexing & Ranking
  • ⭐️ Beginner

Assign Rank1 and Rank2

Challenge No. 691: Give the rank1 and rank2 as shown.
Solved using: Python.

February 10, 2026July 21, 2025
Transpose Table With Profit
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Transpose Table With Profit

Challenge No. 670: Transpose the table as shown.
Solved using: Python.

January 31, 2026July 21, 2025
Match Names with Same Initials
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Match Names with Same Initials

Challenge No. 612: List the names if first character of first name and first character of last name are same.
Solved using: Python.

January 2, 2026July 11, 2025
Count Unique Uncommon Words
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Count Unique Uncommon Words

Challenge No. 610: Find the number of un-common unique words between Sentence1 and Sentence2.
Solved using: Python.

January 1, 2026December 31, 2025
Transpose the data as shown
Posted in
  • ExcelBI Power Query Challenges
  • ⭐️⭐️ Easy

Transpose the data as shown

Challenge No. 277: Transpose the data as shown.
Solved using: Python.

December 27, 2025July 14, 2025
Transpose the table as shown
Posted in
  • ExcelBI Power Query Challenges
  • ⭐️⭐️⭐️ Intermediate

Transpose the table as shown

Challenge No. 273: Transpose the table as shown.
Solved using: Python.

December 23, 2025July 14, 2025
Pick top N by group
Posted in
  • Custom Grouping
  • ExcelBI Power Query Challenges
  • Indexing & Ranking
  • ⭐️⭐️ Easy

Pick top N by group

Challenge No. 271: From first group, pick up top 1 on the basis of revenue, from second group, pick up top 2 and so on.
Solved using: Python in Excel.

December 21, 2025July 14, 2025
Prepare the result table on
Posted in
  • ExcelBI Power Query Challenges
  • ⭐️ Beginner

Prepare the result table on

Challenge No. 247: Prepare the result table on the basis of problem tables 1 & 2.
Solved using: Python.

November 29, 2025July 14, 2025
Rank Sales Drop Per Person
Posted in
  • ExcelBI Power Query Challenges
  • Indexing & Ranking
  • ⭐️⭐️ Easy

Rank Sales Drop Per Person

Challenge No. 239: Transpose the problem table into result table and calculate the drop in sales amount from one quarter to previous quarter.
Solved using: Python.

November 22, 2025July 14, 2025

Posts pagination

1 2 … 18 Next
  • 96 Common Challenges in Power Query
  • Advanced Mathematics Problem
  • Aggregation & Summarization
  • Books
  • Column Splitting
  • Column Transformation
  • Crispo Challenges
  • Custom Aggregation & Summarization
  • Custom Grouping
  • Data Cleaning
  • Data Transformation
  • data validation
  • Date & Time Handling
  • Excel Challenges
  • ExcelBI Excel Challenges
  • ExcelBI Power Query Challenges
  • Financial Problems
  • Indexing & Ranking
  • Merging & Joining
  • Missing Values
  • Omid Challenges
  • Pivot & Unpivot
  • Power Query Challenges
  • Python Challenges
  • Text Processing
  • ⭐️ Beginner
  • ⭐️⭐️ Easy
  • ⭐️⭐️⭐️ Intermediate
  • ⭐️⭐️⭐️⭐️ Advanced
  • ⭐️⭐️⭐️⭐️⭐️Expert
  • ⭐️⭐️⭐️⭐️⭐️⭐️Complex

BYROW CHAR CODE CONCAT DROP FILTER HSTACK IF IFERROR INDEX LAMBDA LEFT LEN LET List.Distinct List.Transform LOOKUP MAP MATCH MAX MID MONTH Python Python Automation Python for Data Analysis Python for Excel REDUCE ROW ROWS SCAN SEQUENCE SORT SUBSTITUTE Table.AddColumn Table.Group Table.SelectRows TAKE Text.Combine Text.Split TEXTJOIN TEXTSPLIT TOCOL UNIQUE VSTACK XLOOKUP

Recent Posts

  • Max Total on Consecutive Days
  • Extract Valid Year Ranges
  • Swap Grid Diagonals
  • Pivot with Total Line
  • Remove One Letter Palindrome

Recent Comments

No comments to show.
Copyright © 2026 OmidBI.
Powered by WordPress and HybridMag.
  • By Difficulty
    • ⭐️ Beginner
    • ⭐️⭐️ Easy
    • ⭐️⭐️⭐️ Intermediate
    • ⭐️⭐️⭐️⭐️ Advanced
    • ⭐️⭐️⭐️⭐️⭐️Expert
    • ⭐️⭐️⭐️⭐️⭐️⭐️Complex
  • By Topic
    • Advanced Mathematics Problem
    • Aggregation & Summarization
    • Column Splitting
    • Column Transformation
    • Custom Grouping
    • Data Cleaning
    • Data Transformation
    • Date & Time Handling
    • Financial Problems
    • Indexing & Ranking
    • Merging & Joining
    • Missing Values
    • Pivot & Unpivot
    • Text Processing
  • By Creator
    • Omid Challenges
    • ExcelBI Excel Challenges
    • ExcelBI Power Query Challenges
    • Crispo Challenges
  • By Software
    • DAX Challenges
    • Excel Challenges
    • Excel VBA Challenges
    • Google Sheets Challenges
    • Office Script Challenges
    • Power Query Challenges
    • Python Challenges
    • R Challenges
    • SQL Challenges
  • Books
    • 96 Common Challenges in Power Query