…DAX, DAX is the language that we use when we just created these calculated columns,…such as heres unit price minus discount or the calculated feel.…If I click in this cell and…I go insert function, I can come through and pick whatever function I want.…Look at logical.…There's our standard logicals.…And come down to all.…And if I drill down, going to double click Calculate.…
Now Intelisense pops up and tries to help me.…I have Calculate here, and then I'm going to insert an expression.…Actually, I'm not going to, that's the next thing you would do,…which is why this is bolded.…And then, comma Filter1, comma Filter2, and then the ellipses, on and on.…I point out Calculate, even though this is just an introduction to just a touch on…DAX because Calculate is perhaps the most…powerful expression or function there is in all of DAX.…It's something, when you get more into DAX,…you absolutely want to take a look at.…
Calculate is similar to the I, if function over in Excel.…What it gives you the ability to do, is to add expressions that we just did,…
Author
Released
8/20/2014- Working with data sources and data views in SQL
- Understanding the star and snowflake database schemas
- Working with the SQL 2012 semantic model (aka tabular mode)
- Using Data Analysis Expressions (DAX)
- Using Excel Web Parts to connect to spreadsheets
- Building dashboards with key performance indicators (KPIs) and reports
- Understanding the Microsoft data-mining process
Skill Level Intermediate
Duration
Views
Related Courses
-
Excel 2013: Pivot Tables
with Curt Frye4h 20m Intermediate -
Excel 2013 Essential Training
with Dennis Taylor6h 32m Intermediate
-
Introduction
-
Welcome59s
-
What you should know1m 42s
-
Exercise files36s
-
-
1. The Traditional Multidimensional Model
-
Data sources3m 43s
-
Data views2m 16s
-
Cubes5m 35s
-
Hierarchies3m 41s
-
Perspectives2m 11s
-
Star and snowflake schemas3m 45s
-
2. The New Tabular Model
-
The tabular model2m 14s
-
Grid and diagram views3m 22s
-
Data sources5m 56s
-
Relationships4m 57s
-
Measures2m 51s
-
Hierarchies and perspectives2m 19s
-
Process and deploy1m 27s
-
-
3. Basic Power Pivot
-
Power Pivot and Excel3m 53s
-
Enriching data2m 6s
-
-
4. SharePoint Excel Services
-
Excel Web Access (EWA)3m 25s
-
Saving and sharing1m 29s
-
Excel Web Parts2m 35s
-
-
5. Basic PerformancePoint
-
Dashboard Designer3m 46s
-
Data sources5m 33s
-
Objective KPIs3m 54s
-
Scorecards5m 40s
-
Visual reports5m 48s
-
Filters5m 38s
-
Dashboards3m 38s
-
6. SharePoint Visio Services
-
7. Data Mining and Predictive Analytics
-
Why data mining?3m 20s
-
Key concepts3m 12s
-
Data-mining tasks4m 28s
-
Microsoft algorithms4m 31s
-
-
Conclusion
-
Next steps46s
-
- 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.
CancelTake 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.
Share this video
Embed this video
Video: Data Analysis Expressions (DAX)