Getting Started with DAX in Excel [FULL COURSE]
DAX is the formula language that is built into Power Pivot (it's also available in Power BI but this session covers Power Pivot in Excel).
If you're new to DAX or simply curious as to how it can help you to take your Pivot Tables and reporting capabilities to the next level, this is a must-attend session!
Topics covered:
Use DAX to Create a Simple Subtraction Formula to Calculate Profit
Using the LOOKUPVALUE Function (The DAX version of VLOOKUP)
Measures v Calculated Columns
Create a DAX Measure
The CALCULATE Function and Why it's Important
CUBE Functions - the What and How
⏱ Timestamps
00:00:00 Introduction
00:02:05 What is DAX?
00:03:09 Create a Profit Column (Revenue - Costs)
00:10:50 Extract Day Names from Dates to Create a Slicer
00:14:07 The LOOKUPVALUE Function
00:19:50 Creating Simple Measures: SUM and COUNTROWS
00:37:56 Add Filters to Your Measures with the CALCULATE Function
00:53:32 The CUBEVALUE Function
✅ Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at https://theexceltrainer.co.uk
🙋♂️ Let's connect on social
Twitter: / theexceltrainer
Facebook: / theexceltrainer
LinkedIn: / thomasmik
#excel #powerpivot #dax