In this video, the instructor introduces the formula language that enables you to create powerful calculated fields from a data model: Data Analysis Expressions (DAX).
- [Instructor] Okay, let's talk about…what data analysis expressions are all about.…Now, simply put, DAX is the formula language…that drives Power Pivot.…And with DAX you can do a few different things.…You can create calculated columns…and measures to your model, using intuitive syntax,…and you can go well beyond the capabilities…of those grid style formulas…and functions that you're used to.…Because these functions are built specifically…to work with relational data and data models.…
Now, the one biggest takeaway on this slide…is that there are two places to use DAX.…The first place is the calculated column,…and you'll see these in the data view…of your data model window.…You'll always see this extra add column field,…and that's where you can use DAX to create…brand new calculated columns.…The second place to use DAX is a measure,…and you can add measures from a number of different places,…but we'll be using them primarily…in the pivot table window to calculate…some really cool new fields.…
So, that's your quick intro to DAX.…
- Power Pivots versus normal pivots
- Creating calculated columns and measures
- Power Pivot and DAX best practices
- Math, stats, and COUNT functions
- CALCULATE, FILTER, and ALL functions
- Joining data with RELATED
- Using iterator functions (SUMX and RANKX)
- Time intelligence formulas
Skill Level Intermediate
1. Getting Started
Set expectations1m 46s
2. Power Pivot and DAX 101
3. Common DAX Functions
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.