This page was inspired by a presentation by Chandoo to whom I a very grateful.

The page sets out how to use Power Query to find how many people have joined Acme plc between January and February, how many have left, how many have moved from one group to another … and so on.

To do all of this we create a conditional column in Power Query … download my instructional PDF file and take a trip to chandoo.org to download his churn data file and follow along with me here!

 

employee_churn_PQ_chandoo

Duncan Williamson

22nd March 2017

 

%d bloggers like this: