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
Exclude Weekend Leave Days
Posted in
  • Date & Time Handling
  • ExcelBI Power Query Challenges
  • ⭐️⭐️ Easy

Exclude Weekend Leave Days

Challenge No. 234: Find the total leaves taken by the employees.
Solved using: Python.

November 19, 2025July 14, 2025
Complete Square by X Placeholder
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️⭐️ Intermediate

Complete Square by X Placeholder

Challenge No. 524: Fill in the digit marked as X to make the number a perfect square.
Solved using: R.

November 19, 2025July 30, 2025
Build Alphabet Staircase
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Build Alphabet Staircase

Challenge No. 523: Make the staircase of alphabets.
Solved using: Excel VBA.

November 18, 2025July 30, 2025
Calculate Shipped Fruit Value
Posted in
  • ExcelBI Power Query Challenges
  • ⭐️⭐️ Easy

Calculate Shipped Fruit Value

Challenge No. 233: Calculate the Shipped and Non-shipped amounts (Quantity * Price) for all Fruits.
Solved using: Python.

November 18, 2025July 14, 2025
Sum of Odd Numbers Sequence
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️⭐️ Intermediate

Sum of Odd Numbers Sequence

Challenge No. 522: Check if a number can be expressed as a sum of consecutive odd numbers.
Solved using: Python in Excel.

November 18, 2025July 30, 2025
Pair Swipes
Posted in
  • Crispo Challenges
  • ⭐️⭐️ Easy

Pair Swipes

Challenge No. 73: Pair the staff Swipes.
Solved using: R.

November 17, 2025July 11, 2025
List Dates with Unique Digits
Posted in
  • Date & Time Handling
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

List Dates with Unique Digits

Challenge No. 521: List all dates containing unique digits between 1900-01-01 to 2999-12-31.
Solved using: Python in Excel.

November 17, 2025July 30, 2025
Repeat Rows Until Next Date
Posted in
  • Date & Time Handling
  • ExcelBI Power Query Challenges
  • ⭐️⭐️⭐️⭐️ Advanced

Repeat Rows Until Next Date

Challenge No. 232: Repeat a row till the next date.
Solved using: Python in Excel.

November 17, 2025July 14, 2025
Align Rowwise Data
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Align Rowwise Data

Challenge No. 520: Align the data as given in answer expected.
Solved using: Python in Excel.

November 17, 2025July 30, 2025
Matching Digit Sums
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Matching Digit Sums

Challenge No. 519: Find first 25 numbers starting with two digits where sum of individual digits of (Number = Square of Number = Cube of Number)
Ex.
Solved using: Python.

November 16, 2025July 30, 2025

Posts pagination

Previous 1 … 20 21 22 … 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