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
Unpivot the table, add order
Posted in
  • ExcelBI Power Query Challenges
  • Pivot & Unpivot
  • ⭐️⭐️⭐️ Intermediate

Unpivot the table, add order

Challenge No. 276: Unpivot the table.
Solved using: Python in Excel.

December 26, 2025July 14, 2025
Find Step Harshad Palindromes
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️⭐️⭐️⭐️Expert

Find Step Harshad Palindromes

Challenge No. 598: List Palindromic Step Harshad numbers less than 10 million starting with double digit numbers.
Solved using: Python in Excel.

December 26, 2025July 11, 2025
Draw a Pentagram Symbol
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️⭐️ Intermediate

Draw a Pentagram Symbol

Challenge No. 597: Prepare a Pentagram..
Solved using: Python.

December 25, 2025July 11, 2025
Transpose table, summing values from
Posted in
  • ExcelBI Power Query Challenges
  • ⭐️ Beginner

Transpose table, summing values from

Challenge No. 275: Transpose the problem table into result table where value is sum of Values from problem table.
Solved using: Python.

December 25, 2025July 14, 2025
Sequential Group Numbering Logic
Posted in
  • Custom Grouping
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Sequential Group Numbering Logic

Challenge No. 596: This challenge is contributed by Ankur Sharma
Populate 1, 2, 3.
Solved using: Python.

December 25, 2025July 11, 2025
Calculate Monthly Day Totals
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️⭐️ Intermediate

Calculate Monthly Day Totals

Challenge No. 595: This challenge is contributed by 🇰🇷 Taeyong Shin
Create a table that calculates the number of weekdays, Saturdays, and Sundays using yearly and monthly data, and displays the total number of days in each month.
Solved using: Python in Excel.

December 24, 2025July 11, 2025
Check ingredient availability for dishes
Posted in
  • ExcelBI Power Query Challenges
  • ⭐️⭐️ Easy

Check ingredient availability for dishes

Challenge No. 274: Problem Table1 contains the list of ingredients which can be used to prepare a dish.
Solved using: Python.

December 24, 2025July 14, 2025
Reapply Original Capitalization
Posted in
  • ExcelBI Excel Challenges
  • Indexing & Ranking
  • ⭐️ Beginner

Reapply Original Capitalization

Challenge No. 594: Work out the indexes where capital letters are.
Solved using: Python in Excel.

December 24, 2025July 11, 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
Generate Bell Number Triangle
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️⭐️ Intermediate

Generate Bell Number Triangle

Challenge No. 592: Prepare Bell Triangle for given n where n is number of rows.
Solved using: Python.

December 23, 2025

Posts pagination

Previous 1 … 10 11 12 … 117 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