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
Insert Yearly Sum Totals
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Insert Yearly Sum Totals

Challenge No. 660: Insert the sum for the year after the year ends.
Solved using: Python.

January 26, 2026July 21, 2025
Cube With Equal Digits
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Cube With Equal Digits

Challenge No. 659: Find those 2 digits to 5 digits numbers whose cube results into numbers where frequency of appearing digits are same.
Solved using: Python.

January 25, 2026July 21, 2025
Check Valid Word Square
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Check Valid Word Square

Challenge No. 658: Word Square – A word square is a n x n matrix where row (i) = column (i).
Solved using: Python.

January 25, 2026July 21, 2025
Largest Alternating Digit Substring
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️⭐️⭐️ Advanced

Largest Alternating Digit Substring

Challenge No. 657: Find the largest substring number which has alternating odd/even or even/odd digits.
Solved using: R.

January 24, 2026July 21, 2025
Find Project Critical Path
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️⭐️ Intermediate

Find Project Critical Path

Challenge No. 656: This challenge is contributed by Abdelrahman Omer, MBA, PMP
Find the critical path and its duration for this project.
Solved using: Python.

January 24, 2026July 21, 2025
Detect Sequence Direction
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Detect Sequence Direction

Challenge No. 655: Find whether a sequence is increasing (I), decreasing (D) or neither of these (N).
Solved using: Python.

January 23, 2026July 21, 2025
Percentage Share Per Group
Posted in
  • Custom Grouping
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Percentage Share Per Group

Challenge No. 654: Work out the % Revenue share of each year within a group where % = Revenue / Sum of Revenue of a Group.
Solved using: Python in Excel.

January 23, 2026July 21, 2025
Last Sundays Of Year
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Last Sundays Of Year

Challenge No. 653: List the last Sundays of the all 12 months of year given in cell A2.
Solved using: Python in Excel.

January 22, 2026
Generate Sequential Tickets
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Generate Sequential Tickets

Challenge No. 652: Generate the ticket numbers as given.
Solved using: Python.

January 22, 2026July 21, 2025
Create Vortex Number Grid
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️⭐️⭐️⭐️Expert

Create Vortex Number Grid

Challenge No. 651: This challenge is contributed by Mehmet Çiçek
Create the vortex grid of numbers (n x n) for a value given in column A.
Solved using: Python in Excel.

January 21, 2026July 21, 2025

Posts pagination

Previous 1 … 4 5 6 … 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