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
Leave Days by Priority
Posted in
  • Date & Time Handling
  • ExcelBI Power Query Challenges
  • ⭐️⭐️⭐️⭐️⭐️⭐️Complex

Leave Days by Priority

Challenge No. 152: The table contains dates of only one year.
Solved using: R.

September 8, 2025July 14, 2025
Draw Square With X Pattern
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Draw Square With X Pattern

Challenge No. 380: Draw an N x N square where sides and diagonals are filled with x.
Solved using: Python.

September 8, 2025July 22, 2025
Numbers With Larger Successors
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Numbers With Larger Successors

Challenge No. 379: List all the numbers where all succeeding numbers are larger than the number.
Solved using: Python.

September 7, 2025July 22, 2025
Billable Hours by Weekday
Posted in
  • Date & Time Handling
  • ExcelBI Power Query Challenges
  • ⭐️⭐️⭐️⭐️⭐️Expert

Billable Hours by Weekday

Challenge No. 151: Work out the total hours spent by an employee (Table T1).
Solved using: Python in Excel.

September 7, 2025July 14, 2025
Split on First Greater Sum
Posted in
  • Column Splitting
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Split on First Greater Sum

Challenge No. 378: Split the numbers into two parts where sum of first part is > sum of second part where it happens for the first time.
Solved using: R.

September 7, 2025July 22, 2025
Encrypt Text with Keyword Cipher
Posted in
  • ExcelBI Excel Challenges
  • Text Processing
  • ⭐️⭐️ Easy

Encrypt Text with Keyword Cipher

Challenge No. 377: Encrypt the gives words using Keyword Cipher.
Solved using: Python.

September 6, 2025July 22, 2025
Fill Missing Time Fields
Posted in
  • ExcelBI Power Query Challenges
  • ⭐️⭐️⭐️⭐️ Advanced

Fill Missing Time Fields

Challenge No. 150: You need to fill in the blanks.
Solved using: Python.

September 6, 2025
Multiply Fibonacci and Lucas Numbers
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Multiply Fibonacci and Lucas Numbers

Challenge No. 376: Lucas Numbers – A term is sum of immediate previous two terms.
Solved using: Python.

September 6, 2025July 22, 2025
Convert Marks to Grade Points
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Convert Marks to Grade Points

Challenge No. 375: Calculate the grade points for given marks.
Solved using: Python in Excel.

September 5, 2025July 22, 2025
Monthly Per Diem Calculation
Posted in
  • Column Splitting
  • Date & Time Handling
  • ExcelBI Power Query Challenges
  • ⭐️⭐️⭐️⭐️ Advanced

Monthly Per Diem Calculation

Challenge No. 149: The data is for business trip start and end dates of employees.
Solved using: Python.

September 5, 2025July 14, 2025

Posts pagination

Previous 1 … 42 43 44 … 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