Microsoft Power BI DAX from Scratch
What you'll learn
- 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
Requirements
- Power BI desktop installed
- A basic understanding of Power BI desktop
- Know how to create data models
Description
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
Who this course is for:
- Anyone dealing with report creation and providing data insights.
Instructors
- 4.5 Instructor Rating
- 17,146 Reviews
- 448,154 Students
- 30 Courses
Learnsector, your one-stop solution for all your training needs. We're dedicated to giving you the best in class training in the space of Programming, Cyber Security, Cloud, Machine Learning, Analytics, and Project Management.
Our exclusive training helps you to acquire the relevant skillset mandatory to grab thriving opportunities. We train you intensively to implement your technical skills in a real-world scenario. We help you stay up-to-date with the latest technologies and requirements of IT organizations across the world.
- 4.5 Instructor Rating
- 11,708 Reviews
- 254,728 Students
- 5 Courses
Navya Kannan is a passionate analytics instructor and experienced BI consultant who brings real-world insight into every lesson. With years of experience working in software compliance, risk consulting, and data reporting, she knows exactly how businesses use data to make decisions—and how to teach you to do the same.
Her courses are designed for practical learning, drawing from real projects she’s delivered using Microsoft Excel, Power BI, and data automation tools. Whether it’s building executive dashboards or automating reports, Navya focuses on skills you can apply from day one.
What sets her apart? It’s her ability to explain even complex topics in a way that feels simple, clear, and empowering. Her learners often say it feels like learning from a colleague who genuinely wants you to succeed.
Trained thousands of professionals on Udemy, earning top ratings for her clarity and relatable teaching style. With her guidance, you won’t just learn the tools—you’ll learn how to think like a data professional and deliver insights that matter.