Tags: AVERAGEX

Compute an average for the same day in the past 3 years

{ 4 Comments }

Assume a simple two column dataset with dates in column A and numbers in column B. The dates in column A are from January 1, 2013 to December 31, 2016 and numbers in column B are for the period January 1, 2013 to December 31, 2015 (there are no numbers for January 1, 2016 to […]

Read More →

Data slicing and analysis with the Power Pivot

{ 0 Comments }

Visualise an MS Excel file with two worksheets: Employee headcount – a multi column dataset with information such as Employee code, Date of Joining, Age, Division, Department and Location.  Each row represents data for one employee.  The number of rows on this worksheet is approximately 700. Training Data – a multi column dataset with information […]

Read More →