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
  • Latest
  • Omid Challenges
  • ExcelBI Power Query Challenges
  • ExcelBI Excel Challenges
  • Crispo Challenges

Max Total on Consecutive Days

February 16, 2026July 21, 2025

Extract Valid Year Ranges

February 16, 2026July 21, 2025

Swap Grid Diagonals

February 15, 2026July 21, 2025

Pivot with Total Line

February 15, 2026July 21, 2025
View More
Solving People Connection challenge by Power Query, Power BI, Excel, Python and R

People Connection!

August 19, 2025July 11, 2025
Solving Column Combining Part 2 challenge by Power Query, Power BI, Excel, Python and R

Column Combining! Part 2

August 18, 2025July 11, 2025
Solving Matrix Calculation Part 2 challenge by Power Query, Power BI, Excel, Python and R

Matrix Calculation! Part 2

August 17, 2025July 11, 2025
Solving Custom Grouping Part 19 challenge by Power Query, Power BI, Excel, Python and R

Custom Grouping! Part 19

August 16, 2025July 11, 2025
View More

Transpose table, compute gross profit

December 28, 2025July 14, 2025

Transpose the data as shown

December 27, 2025July 14, 2025

Unpivot the table, add order

December 26, 2025July 14, 2025

Transpose table, summing values from

December 25, 2025July 14, 2025
View More

Max Total on Consecutive Days

February 16, 2026July 21, 2025

Extract Valid Year Ranges

February 16, 2026July 21, 2025

Swap Grid Diagonals

February 15, 2026July 21, 2025

Pivot with Total Line

February 15, 2026July 21, 2025
View More

Split Periods For The Project

November 20, 2025July 11, 2025

Pair Swipes

November 17, 2025July 11, 2025

Create Weekly Group

November 14, 2025July 11, 2025

Extract and SuM

November 11, 2025July 11, 2025
View More
Max Total on Consecutive Days
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Max Total on Consecutive Days

Challenge No. 703: Today’s challenge is contributed by Duy Tùng
It is required to calculate the total for each employee over consecutive (or separate) days and take the maximum value.
Solved using: Python.

February 16, 2026July 21, 2025
Extract Valid Year Ranges
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️⭐️ Intermediate

Extract Valid Year Ranges

Challenge No. 702: Extract the years from the given data.
Solved using: Python in Excel.

February 16, 2026July 21, 2025
Swap Grid Diagonals
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Swap Grid Diagonals

Challenge No. 701: Swap the diagonals in 10×10 grid as shown.
Solved using: Python in Excel.

February 15, 2026July 21, 2025
Pivot with Total Line
Posted in
  • ExcelBI Excel Challenges
  • Pivot & Unpivot
  • ⭐️ Beginner

Pivot with Total Line

Challenge No. 700: Pivot the given data by summing up the values.
Solved using: Python.

February 15, 2026July 21, 2025
Remove One Letter Palindrome
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Remove One Letter Palindrome

Challenge No. 699: Only one alphabet can be removed from Words list and it should become a palindrome.
Solved using: Python.

February 14, 2026July 21, 2025
Fill Missing Monthly Values
Posted in
  • ExcelBI Excel Challenges
  • Missing Values
  • ⭐️⭐️ Easy

Fill Missing Monthly Values

Challenge No. 698: Populate all months of the year.
Solved using: Python.

February 14, 2026July 21, 2025
Evaluate Student Subject Status
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Evaluate Student Subject Status

Challenge No. 697: Document Pass or Fail against all students.
Solved using: Python in Excel.

February 13, 2026July 21, 2025
Evaluate Pass Based on Subjects
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Evaluate Pass Based on Subjects

Challenge No. 696: Document Pass or Fail against all students.
Solved using: Python in Excel.

February 13, 2026July 21, 2025
Create 2025 Broadcast Calendar
Posted in
  • Date & Time Handling
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Create 2025 Broadcast Calendar

Challenge No. 695: Develop Broadcast Calendar for 2025.
Solved using: Python.

February 12, 2026July 21, 2025
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

Posts pagination

1 2 … 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