From the course: Excel Business Intelligence: Power Pivot and DAX
Unlock this course with a free trial
Join today to access over 22,600 courses taught by industry experts.
The CALCULATE function - Microsoft Excel Tutorial
From the course: Excel Business Intelligence: Power Pivot and DAX
The CALCULATE function
- [Instructor] So up until this point, you might be asking yourself, what's so special about this DAX language anyway? Based on what we've looked at so far, these logical operators, these calculated columns, these text formulas, it's all extremely similar to regular old Excel syntax. In fact, in many cases, it's just about identical with the exception that we're pointing to columns and tables instead of individual cells. We've had a few interesting nuggets like distinct count is pretty cool, and switch is a great option. But we haven't really begun to scratch the surface of what DAX is really capable of. And that's gonna change now. Because now we're shifting gears into the DAX filter functions. And these functions are really what starts to set DAX apart as a distinct formula language. And we're gonna kick it off with hands-down, the most popular filter function of all, called calculate. So, calculate basically just evaluates an expression or a formula under a set of defined filters…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
(Locked)
Introduction to DAX functions27s
-
DAX formula syntax and operators4m 5s
-
(Locked)
Common DAX function categories3m 54s
-
(Locked)
Basic math and stats functions12m 45s
-
(Locked)
COUNT, COUNTA, DISTINCTCOUNT, and COUNTROWS10m 35s
-
(Locked)
Logical Functions (IF, AND, and OR)16m 49s
-
(Locked)
Switch and Switch (TRUE)10m 33s
-
(Locked)
Text functions10m 53s
-
(Locked)
The CALCULATE function14m 39s
-
(Locked)
Add filter context with FILTER: Part 19m 20s
-
(Locked)
Add filter context with FILTER: Part 214m 23s
-
(Locked)
Remove filter context with ALL9m 6s
-
Join data with RELATED3m 39s
-
(Locked)
Iterator ("X") functions: SUMX12m 20s
-
(Locked)
Iterator ("X") functions: RANKX5m 33s
-
(Locked)
Basic date and time functions4m 58s
-
(Locked)
Time intelligence formulas17m 2s
-
(Locked)
Speed and performance considerations3m 2s
-
(Locked)
DAX best practices2m 3s
-
(Locked)
-