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 : 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...

1,1070

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...

2040

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...

5380

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...

8690

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...

7,3210

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...

8,8231

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...

5600

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....

7,7721

Marek Vavrovic

- Jun 5, 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...

550

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...

1140

Marek Vavrovic

- Jul 11, 2020
- 4 min

Multiple Linear Regression

Multiple linear regression model is the most popular type of linear regression analysis. It is used to show the relationship between one...

3990

Marek Vavrovic

- Jul 3, 2020
- 8 min

Linear regression analysis in Excel

In statistical modeling, regression analysis is used to estimate the relationships between two or more variables: Dependent variable (aka...

6870

Marek Vavrovic

- Jun 14, 2020
- 7 min

Two-Way ANOVA

A two-way ANOVA test is a statistical test used to determine the effect of two nominal predictor variables on a continuous outcome...

3940

Marek Vavrovic

- Jun 13, 2020
- 4 min

One-way ANOVA

The one-way analysis of variance (ANOVA) is used to determine whether there are any statistically significant differences between the...

3270

Marek Vavrovic

- Jun 9, 2020
- 3 min

Hypothesis testing, F-Ratio, F-Distribution

When to use f-distribution? In investing, variance is used to compare the relative performance of each asset in a portfolio. Because the...

1080

Marek Vavrovic

- Jun 8, 2020
- 3 min

Hypothesis testing, T-Distribution.

Hypothesis testing is just a method for testing a claim or hypothesis about a parameter in a population [mean, proportion]. In hypothesis...

1730

Marek Vavrovic

- Jun 6, 2020
- 5 min

Hypothesis testing, p-value, test statistic, z-score.

Hypothesis testing is just a method for testing a claim or hypothesis about a parameter in a population [mean, proportion]. In hypothesis...

1530

Marek Vavrovic

- May 29, 2020
- 4 min

The Normal Distribution

Statisticians call a distribution with a bell-shaped curve a normal distribution. You may have heard of a bell curve. A bell curve...

220