4.46 out of 5
4.46
34 reviews on Udemy

Microsoft Power BI DAX from Scratch

Hands-on guide to Microsoft Power BI DAX
Instructor:
Learnsector LLP
10,497 students enrolled
English [Auto]
A beginner to intermediate guide on how to create DAX formula
Understand the concept of calculated column, measures, and tables in DAX
How to solve the problem statement using various DAX function

If you are someone dealing with reporting, with the help of DAX functions you can unlock the advanced power of reporting in Power BI. These functions will help you get better data insights.

DAX or Data Analysis Expression is a library of functions and operators, using which you can create formulas and expressions. This will help you with creating powerful formulas to ease your data analysis and reporting process.

This course is designed in a Problem Statement – Solution format where we start with the problem to which a solution is sought with the help of DAX functions where each component of the expression is clearly explained in easy-to-understand terms,

What is in store for you?

In this course, you will

1. Understand the concept of DAX and how to create calculate column, measure, tables, and quick measures

2. From the exhaustive list of DAX functions, we will be looking into the most frequently used functions from the family of

  • Date and Time function – WEEKDAY,  EDATE, EOMONTH,  DATEDIFF, TODAY, NOW
  • Text function – FORMAT, COMBINEVALUES, LEFT, RIGHT, FIND, UPPER, LOWER, UNICHAR, REPT
  • Logical function – IF, Nested IF, AND, OR, SWITCH
  • Relationship function – RELATED, CROSSFILTER, RELATEDTABLE
  • X-function – SUMX, RANKX
  • Filter function – CALCULATE, ALL, EARLIER, FILTER, LOOKUPVALUE
  • Statistical function – DISTINCTCOUNT
  • Time intelligence function- DATESYTD, DATEADD, SAMEPERIODLASTYEAR
  • Information function- CONTAINS
  • Table manipulation function- SUMMARIZECOLUMNS 

 

You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.5
4.5 out of 5
34 Ratings

Detailed Rating

Stars 5
15
Stars 4
15
Stars 3
4
Stars 2
0
Stars 1
0
ce8b3553ee34d0a038a4483d9f3323f0
Course available for 1 day
30-Day Money-Back Guarantee

Includes

3 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion
2