From the course: Power BI Data Analyst Associate (PL-300) Cert Prep: Create Model Calculations Using DAX
Unlock the full course today
Join today to access over 24,700 courses taught by industry experts.
Recap of functions - Power BI Tutorial
From the course: Power BI Data Analyst Associate (PL-300) Cert Prep: Create Model Calculations Using DAX
Recap of functions
- Functions are predetermined formulas that perform calculations using arguments in a specific order or structure. These arguments can be formulas, expressions, references to other columns, numbers, text, Boolean values, or even other functions. When working with DAX, you'll have specific categories of functions that you can call on depending on your goals. There are over 250 functions index. So when preparing for the PL-300 Exam, you'll need to get exposed to as many as you can, and you'll need to practice as much as you can. Usually, the function name will give you an indication as to what the function does, and the value it returns. So, an exam tip for you, the best way to learn DAX is practice. The DAX Reference Guide on the Microsoft Power BI Documentation site provides a full list of the DAXs functions, and a description of each. It also has examples that you can copy and paste into Power BI that helps you to…
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)
Recap of functions2m 24s
-
(Locked)
Row and filter contexts6m 58s
-
(Locked)
Using the CALCULATE function2m 44s
-
(Locked)
Creating dates with CALENDAR and CALENDARAUTO3m 48s
-
(Locked)
Accessing related data with the RELATED function2m 22s
-
(Locked)
Overriding default relationships with functions2m 44s
-
(Locked)
Time-intelligence functions4m 37s
-
(Locked)
Statistical functions3m 48s
-
(Locked)
-
-