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
Import .CSV files from web site
Data Refresh - Expression.Error column not found
Covid-19 Dashboard
AdventureWorksDW2017 Dashboard
Wide World Importers Dashboard
Slovakia covid-19
DAX measures for Covid-19
Tesla 2009-2020 Financial reports analysis
Covid 19 Dashboard (OWID)
Huffner Textile Dashboard
Northwind dashboard
File System Task
Sequence Container
Execute SQL Task
For Loop Container
Foreach Loop Container