In this video, the instructor introduces and demonstrates several common logical functions in DAX, including IF, IFERROR, AND, OR, etc.
- All right.…Next up we are moving on to basic logical functions.…So, these are your IF, AND, OR operators, your IFERROR.…And these are gonna look very, very similar…to how they look in Excel.…And we're gonna shift gears a little bit.…Up to this point, we've been using measures…because we've been using statistical and math functions…that return individual values,…so they don't really make sense as calculated columns.…On the other hand, logical functions like these…make a lot more sense as calculated columns.…
So, we're gonna shift gears,…we're gonna add these fields in the data model,…and we're gonna write them…almost exactly how we would write them…in a normal Excel cell.…So, first off, IF.…It checks if a given condition is met…and returns one value if true, another if false.…So, this is exactly the same syntax…as a normal cell function.…So, IF, start with your logical test.…That could be something as simple as checking if a column…is less than, greater than, equal to…a certain numerical value,…or if a text column is equal to a particular string,…
- 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.