Once you’ve discovered Power Pivot and learned how to import your data from multiple sources, the next task is to clean it all up. With DAX, we have a new language that can clean and manipulate our data to business friendly rules and names. First we’ll cover an introduction to DAX, and some functions that we can use to manipulate strings, if…then conditions, and navigation. Then we’ll cover how to incorporate time intelligence and building key performance indicators, all from within Power Pivot!