Microsoft Power BI DAX from Scratch

Microsoft Power BI DAX from Scratch, available at $54.99, has an average rating of 4.4, with 30 lectures, 8 quizzes, based on 1081 reviews, and has 61403 subscribers.

You will learn about 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 This course is ideal for individuals who are Anyone dealing with report creation and providing data insights. It is particularly useful for Anyone dealing with report creation and providing data insights.

Enroll now: Microsoft Power BI DAX from Scratch

Summary

Title: Microsoft Power BI DAX from Scratch

Price: $54.99

Average Rating: 4.4

Number of Lectures: 30

Number of Quizzes: 8

Number of Published Lectures: 30

Number of Published Quizzes: 6

Number of Curriculum Items: 38

Number of Published Curriculum Objects: 36

Original Price: $89.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

Anyone dealing with report creation and providing data insights.

Target Audiences

Anyone dealing with report creation and providing data insights.

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 – Solutionformat 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

Course Curriculum

Chapter 1: DAX – Introduction

Lecture 1: Getting Started

Lecture 2: Syntax

Lecture 3: Intro to DAX

Chapter 2: DAX – DATE and TIME Function

Lecture 1: WEEKDAY Function

Lecture 2: EDATE Function

Lecture 3: EOMONTH Function

Lecture 4: DATEDIFF and TODAY Function

Chapter 3: DAX – TEXT Function

Lecture 1: FORMAT Function

Lecture 2: COMBINEVALUES Function

Lecture 3: LEFT and FIND Function

Chapter 4: DAX – LOGICAL Function

Lecture 1: IF Function

Lecture 2: NESTEDIF Function

Lecture 3: AND FUNCTION

Lecture 4: OR Function

Lecture 5: SWITCH Function

Chapter 5: DAX – RELATIONSHIP Function

Lecture 1: RELATED Function

Lecture 2: CROSSFILTER

Chapter 6: DAX – X FUNCTION

Lecture 1: X FUNCTIONS

Chapter 7: DAX – FILTER Function

Lecture 1: ALL Function

Lecture 2: EARLIER and FILTER Function

Lecture 3: LOOKUPVALUE

Chapter 8: DAX – STATISTICAL Function

Lecture 1: DISTINCTCOUNT Function

Lecture 2: RANKX Function

Chapter 9: DAX – TIME INTELLIGENCE Function

Lecture 1: DATESYTD Function

Lecture 2: DATEADD Function

Lecture 3: SAMEPERIODLASTYEAR

Chapter 10: DAX – INFORMATION Function

Lecture 1: CONTAINS FUNCTIONS

Chapter 11: NEW TABLE AND QUICK MEASURE

Lecture 1: New Table

Lecture 2: SUMMARIZECOLUMNS

Lecture 3: Quick Measure

Instructors

Learnsector LLP
Learn to Win
Navya Kannan
Software Asset Management Specialist

Rating Distribution

1 stars: 7 votes
2 stars: 19 votes
3 stars: 118 votes
4 stars: 425 votes
5 stars: 512 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

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!

Menu