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...
07479 744442
Power Query : Get the last / max record from a subset
Power Query: Normalizing denormalized table
Customer Retention & Cohort Analysis
Power Query - Extracting web data using URL parts - Building functions to fetch web data.
Seasonal Indices (Seasonal Index)
Calculate Lag and Lead value using power query.
Calculate Net Working Days Using Power Query.
Creating a Rolling Average & Rolling Total using Power Query.
Excel append tables
Append files with different culture format
Multiple Linear Regression
Linear regression analysis in Excel
Two-Way ANOVA
One-way ANOVA
Hypothesis testing, F-Ratio, F-Distribution
Hypothesis testing, T-Distribution.
Hypothesis testing, p-value, test statistic, z-score.
The Normal Distribution