Curiasity | DAX for Power BI

Course / Course Details

DAX for Power BI

Programming

By - Sasikala
0 students
N/A
(0)

Course Description

This course provides a complete introduction to DAX (Data Analysis Expressions) in Power BI, helping learners create powerful calculations, measures, and data models for business intelligence reporting. Students will understand how to use DAX formulas for data analysis, time intelligence, filtering, aggregation, and advanced reporting techniques. The course covers practical examples to improve dashboard performance and create interactive business reports.

Course Outcomes

By the end of this course, learners will be able to:

Understand the fundamentals of DAX syntax and functions in Power BI
Create calculated columns, measures, and calculated tables
Apply filter context and row context effectively
Use aggregation functions like SUM, COUNT, AVERAGE, and DISTINCTCOUNT
Build time intelligence calculations (YTD, MTD, QTD)
Create advanced DAX formulas using IF, SWITCH, CALCULATE, FILTER, and RELATED
Optimize Power BI reports for better performance
Design interactive dashboards with meaningful insights
Solve real-world business reporting challenges using DAX
Improve data analysis and decision-making skills in Power BI

Course Curriculum

1 chapters
36 lectures
0 quizzes
N/A total length

Toggle all chapters

1 DAX for Power BI Part 1 Getting Started with DAX for Power BI

39.05 Min

2 DAX for Power BI Part 2 1 Basic Calculated Columns in DAX

33.25 Min

3 DAX for Power BI Part 2 2 The If Function

30.2 Min

4 DAX for Power BI Part 2 3 The Switch Function

20.51 Min

5 DAX for Power BI Part 2 4 Working with Blanks

19.43 Min

6 DAX for Power BI Part 2 5 Text in Calculated Columns

35.56 Min

7 DAX for Power BI Part 2 6 Dates in Calculated Columns

31.09 Min

8 DAX for Power BI Part 2 7 Error Functions in Calculated Columns

19.03 Min

9 DAX for Power BI Part 3 1 Relationships and the Related Function

25.55 Min

10 DAX for Power BI Part 3 2 The LookupValue Function

22.24 Min

11 DAX for Power BI Part 4 1 Getting Started with Measures

28.58 Min

12 DAX for Power BI Part 4 2 Sum SumX and Other Aggregate Functions

20.21 Min

13 DAX for Power BI Part 4 3 Counting Values and Rows

17.41 Min

14 DAX for Power BI Part 4 4 Using Variables

23.44 Min

15 DAX for Power BI Part 4 5 Quick Measures

19.36 Min

16 DAX for Power BI Part 5 1 The Calculate Filter and CalculateTable Functions

31.04 Min

17 DAX for Power BI Part 5 2 Removing Filters in Measures

26.52 Min

18 DAX for Power BI Part 5 3 Replacing and Keeping Filters in Measures

19.21 Min

19 DAX for Power BI Part 5 4 Removing Filters with AllSelected and AllExcept

25.04 Min

20 DAX for Power BI Part 5 5 The CrossFilter Function

27.1 Min

21 DAX for Power BI Part 6 1 Introduction to Time Intelligence Functions

31.2 Min

22 DAX for Power BI Part 6 2 Comparing Date Ranges

37.45 Min

23 DAX for Power BI Part 6 3 Calculating Running Total or To Date Values

29.53 Min

24 DAX for Power BI Part 6 4 Opening and Closing Balance Calculations

44.53 Min

25 DAX for Power BI Part 7 1 Creating Basic Calendar Tables in DAX

29.35 Min

26 DAX for Power BI Part 7 2 Creating a Financial Year Calendar

31.39 Min

27 DAX for Power BI Part 7 3 Single Calendar vs Multiple Calendars

24.18 Min

28 DAX for Power BI Part 7 4 Rolling Average Calculations

44.09 Min

29 DAX for Power BI Part 8 1 The Values HasOneValue and SelectedValue Functions

51.17 Min

30 DAX for Power BI Part 8 2 The ConcatenateX Function

34.53 Min

31 DAX for Power BI Part 8 3 Disconnected Slicers

38.22 Min

32 Hide All Ads - Subscribe Premium Service Now DAX for Power BI Part 8 4 Disconnected Slicers and Conditional Formatting

34.05 Min

33 DAX for Power BI Part 8 5 Field Parameters

16.31 Min

34 DAX for Power BI Part 9 1 Ranking Values with the RANKX Function

33.14 Min

35 DAX for Power BI Part 9 2 Ranking Values with the RANK Function

27.42 Min

36 DAX for Power BI Part 9 3 Ranking with Substituted Values

29.08 Min

Instructor

Sasikala

0 Rating

0 Reviews

0 Students

82 Courses

Course Full Rating

0

Course Rating

(0)

No Review found

Student Feedback

You must be enrolled to ask a question

Enrol

Duration N/A
Lectures 36 lessons
Enrolled 0 students
Category: Programming
0 Quizzes
Language: English
Skill Level Beginner
Certificate of Completion
Full lifetime access

Shopping Cart

We collect and use cookies to give you the best and most relevant website experience. Kindly accept the cookies. Privacy Policy

When you visit any of our websites, it may store or retrieve information on your browser, mostly in the form of cookies. This information might be about you, your preferences or your device and is mostly used to make the site work as you expect it to. The information does not usually directly identify you, but it can give you a more personalized web experience. Because we respect your right to privacy, you can choose not to allow some types of cookies. Click on the different category headings to find out more and manage your preferences. Please note, that blocking some types of cookies may impact your experience of the site and the services we are able to offer

Strictly Necessary

These cookies are necessary for our website to function properly and cannot be switched off in our systems. They are usually only set in response to actions made by you that amount to a request for services, such as setting your privacy preferences, logging in or filling in forms, or where they’re essential to providing you with a service you have requested. You cannot opt out of these cookies. You can set your browser to block or alert you about these cookies, but if you do, some parts of the site will not then work. These cookies do not store any personally identifiable information
Performance Cookies

These cookies allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us to know which pages are the most and least popular and see how visitors move around the site, which helps us optimize your experience. All information these cookies collect is aggregated and therefore anonymous. If you do not allow these cookies we will not be able to use your data in this way.
Functional Cookies

These cookies enable the website to provide enhanced functionality and personalization. They may be set by us or by third-party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly.
Targeting Cookies

These cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They do not store directly personal information but are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising.