Power Query : Get the last / max record from a subset
Sample data: I have a table where 1 Order Number has multiple record in that. I want to retrieve just the most recent one. 1. Group by...
top of page
07479 744442
Home: SQL
Search
Marek Vavrovic
May 3, 20222 min read
Power Query: Normalizing denormalized table
Sample data: I have this Denormalized table, and I want to put the table into 3rd normal form. Load table into Power Query 2. Duplicate...
3790
Marek Vavrovic
Apr 30, 20223 min read
Customer Retention & Cohort Analysis
Customer cohort analysis is beneficial in marketing and business use cases. For subscription & non-subscription businesses. Companies use...
6510
Marek Vavrovic
Oct 21, 20212 min read
Power Query - Extracting web data using URL parts - Building functions to fetch web data.
Web source: Database index (planecrashinfo.com) Goal is to extract the accident details for each year and date. That means get a access...
1,2250
Marek Vavrovic
Oct 15, 20213 min read
Seasonal Indices (Seasonal Index)
When data under analysis has a seasonal influence on it, further investigation cannot continue without deseasonalising the data. This...
13,8200
Marek Vavrovic
Jun 17, 20212 min read
Calculate Lag and Lead value using power query.
Lag and Lead are functions used in many programming languages that provides access to a row at a specified physical offset which comes...
12,3511
Marek Vavrovic
Jun 16, 20213 min read
Calculate Net Working Days Using Power Query.
We want to calculate number of days between start date and end date. Then we want to exclude weekends. And at the end holidays. Source...
7430
Marek Vavrovic
Jun 10, 20215 min read
Creating a Rolling Average & Rolling Total using Power Query.
A rolling average also known as moving average is a statistical method that calculates the average of a data series for a given period....
9,8402
Marek Vavrovic
Jun 5, 20212 min read
Excel append tables
I have a multiple excel files in one folder with the same metadata (structure). These tables are not proper tables, require some...
71