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
Transpose table: As in one
Posted in
  • ExcelBI Power Query Challenges
  • ⭐️⭐️ Easy

Transpose table: As in one

Challenge No. 268: Transpose the given table as show.
Solved using: R.

December 18, 2025July 14, 2025
Find Time Extremes by Date
Posted in
  • Date & Time Handling
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Find Time Extremes by Date

Challenge No. 582: For different dates, document the min and max time and corresponding employees.
Solved using: Python in Excel.

December 18, 2025July 30, 2025
Number Groups for Letter A
Posted in
  • Custom Grouping
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Number Groups for Letter A

Challenge No. 581: Populate 1 in first group of As and for every succeeding group of As, add 1 to the count.
Solved using: Python.

December 17, 2025July 30, 2025
Work out tiered running totals
Posted in
  • ExcelBI Power Query Challenges
  • ⭐️⭐️ Easy

Work out tiered running totals

Challenge No. 267: Work out the running total for first 10 entries, then next 9 entries, then next 8 entries till you reach 1 entry.
Solved using: Python.

December 17, 2025July 14, 2025
Digit Sum in Fibonacci Sequence
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Digit Sum in Fibonacci Sequence

Challenge No. 580: Let’s code golf.
Solved using: Python.

December 17, 2025July 30, 2025
Find Rotated Matching Words
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️⭐️⭐️ Advanced

Find Rotated Matching Words

Challenge No. 579: List the words from String1 and String2 if they are rotated versions of each other.
Solved using: Python.

December 16, 2025July 30, 2025
Summarise the table with total
Posted in
  • Aggregation & Summarization
  • ExcelBI Power Query Challenges
  • ⭐️⭐️ Easy

Summarise the table with total

Challenge No. 266: Summarise the table as shown with a total row after each sales person’s data.
Solved using: Python.

December 16, 2025July 14, 2025
Top Three Column Products
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Top Three Column Products

Challenge No. 578: Find the top 3 max product from the combination of numbers from 3 columns (Number1, Number2, Number3).
Solved using: Python.

December 16, 2025July 30, 2025
Render a Lamp in ASCII
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Render a Lamp in ASCII

Challenge No. 577: Make an ASCII lamp. .
Solved using: Python.

December 15, 2025July 30, 2025
Sort Consonants Keep Vowels
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Sort Consonants Keep Vowels

Challenge No. 576: Sort the consonants in given sentences while keeping the vowels wherever they are.
Solved using: Python.

December 15, 2025July 30, 2025

Posts pagination

Previous 1 … 12 13 14 … 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