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, 2022
- 2 min
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...
1090
Marek Vavrovic
- Apr 30, 2022
- 3 min
Customer Retention & Cohort Analysis
Customer cohort analysis is beneficial in marketing and business use cases. For subscription & non-subscription businesses. Companies use...
3840
Marek Vavrovic
- Oct 21, 2021
- 2 min
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...
5690
Marek Vavrovic
- Oct 15, 2021
- 3 min
Seasonal Indices (Seasonal Index)
When data under analysis has a seasonal influence on it, further investigation cannot continue without deseasonalising the data. This...
3,1660
Marek Vavrovic
- Jun 17, 2021
- 2 min
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...
6,1890
Marek Vavrovic
- Jun 16, 2021
- 3 min
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...
3740
Marek Vavrovic
- Jun 10, 2021
- 5 min
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....
5,9381
Marek Vavrovic
- Jun 6, 2021
- 2 min
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...
490
Marek Vavrovic
- Jun 5, 2021
- 3 min
Append files with different culture format
I have couple of files with different date and value formats. Will use a function which will format them correctly... Source files: There...
810
