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
Employee Count in Intervals
Posted in
  • ExcelBI Power Query Challenges
  • ⭐️⭐️⭐️ Intermediate

Employee Count in Intervals

Challenge No. 142: Generate the time series between 9AM to 9PM at 15 minutes interval.
Solved using: R.

August 29, 2025July 14, 2025
Reverse Only English Alphabets
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️⭐️⭐️ Advanced

Reverse Only English Alphabets

Challenge No. 360: Reverse the English alphabets in the strings.
Solved using: R.

August 29, 2025July 21, 2025
Sum of Unique Consecutive Numbers
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Sum of Unique Consecutive Numbers

Challenge No. 359: Express the numbers as sum of 2 or more unique consecutive numbers.
Solved using: R.

August 28, 2025July 21, 2025
End of Day Stock Record
Posted in
  • Date & Time Handling
  • ExcelBI Power Query Challenges
  • ⭐️⭐️⭐️⭐️⭐️Expert

End of Day Stock Record

Challenge No. 140: Work out the End of Day Stock.
Solved using: R.

August 28, 2025July 14, 2025
Stack Matrix Diagonals Horizontally
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Stack Matrix Diagonals Horizontally

Challenge No. 358: Stack both the diagonals of n x n metrices horizontally.
Solved using: Python in Excel.

August 28, 2025July 21, 2025
Build Dictionary Excluding Vowels
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Build Dictionary Excluding Vowels

Challenge No. 357: Prepare dictionary entries from Key Value pairs.
Solved using: Python in Excel.

August 27, 2025July 21, 2025
Exclude Weekend Vacation Dates
Posted in
  • Date & Time Handling
  • ExcelBI Power Query Challenges
  • ⭐️⭐️⭐️⭐️ Advanced

Exclude Weekend Vacation Dates

Challenge No. 139: Prepare the Result table.
Solved using: DAX.

August 27, 2025July 14, 2025
Digits with Higher Frequency
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Digits with Higher Frequency

Challenge No. 356: List the digits whose frequency is > frequency of the maximum digit
Ex.
Solved using: R.

August 27, 2025July 21, 2025
Validate IPv6 Address Format
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️⭐️ Intermediate

Validate IPv6 Address Format

Challenge No. 355: List all valid IPv6 addresses.
Solved using: Python in Excel.

August 26, 2025July 21, 2025
Transpose People Table
Posted in
  • ExcelBI Power Query Challenges
  • ⭐️⭐️ Easy

Transpose People Table

Challenge No. 138: Transpose the problem table into result table.
Solved using: R.

August 26, 2025July 14, 2025

Posts pagination

Previous 1 … 45 46 47 … 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