Skip to content
UdemyPower BIPaid courseBeginner levelCertificate

Microsoft Power BI DAX from Scratch (Udemy.com)

Hands-on guide to Microsoft Power BI DAX

Created by: Learnsector LLP

Last updated March 2023

icon
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

How it compares

Against the other 68 rated Udemy courses in Power BI on CourseDuck:

  • Rating4.2 out of 5higher than 5% of them
  • Reviews1,228#45 of 69 by number of reviews
  • Length2.9 hoursshorter than 91% of them
  • Last updatedMarch 2023earlier than 91% of them

icon
Course 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



icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Learnsector LLP

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.

icon
More courses by Learnsector LLP

$29.99

$11.99

$12.99

$10.99

$10.99

$10.99

icon
More Power BI courses

$124.99

$139.99

$24.99

$139.99

$10.99

$10.99

icon
Reviews

4.2

1,228 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

By Sivakumar J on 6/12/2024

The narration is good. I was expecting a detailed explanation, since this DAX is from the scratch, on how the formula works. The transcript is below average, most of the text are not appropriate. Also the quiz that comes after the main section, few of the questions were outside the lesson that was taught in the lesson.

By Soham Rajopadhye on 9/26/2023

Crystal Clear Explanations with Simple Examples. Great Data Set to Practice On Suggestion about the voice : After A point Voice seems monotonous and becomes hard to concentrate for a long time. Thank your for wonderful course

By Jon Montgomery on 3/22/2023

The "Sales" table already had the column and the measure the instructor created. When I created with the instructor, PBI indicated the column and measure had to be renamed. Small concern. Other than that, great first block.

By IncWorx Consulting Learning on 10/19/2022

The screen doesn't always display the teacher's description (25. DATEADD function). The part where the calendar is created is not shown, hence we don't know that a relationship between the calendar table needs to be established for the Time intelligence function to work.

By Alexander Brueck on 7/21/2022

Good introduction and for sure good value for 15 Euros. Just the video recordings had some little errors in them and I missed info on DAX documentation e.g. on Microsoft's and other websites, and perhaps some more content (cases and functions) to work with.

By CF Chiu on 7/6/2022

Soms werd er teveel ingezoomd, waardoor je niet niet wat getypt werd. In les 16 mistte ik de uitleg hoe die precies '429 bikes' komt; dus hoe weet die dat het aantal 429 bij bikes hoort. Verder wel kort en krachtig, maar soms te kort.

By Chandra Shekhar on 3/27/2022

Simple and Cool to follow so far !! Mam- Related could be used on many side of table to get a column from 1 side of relationship. This minute point is missing here rest is very clear and concise.

By Vyacheslav Sarvarov on 8/9/2021

The course is very good as a crash course but the authors did all the job for you i.e. reports, measures, etc already done and included except for several final lessons. It would be much more useful for the students to do it all themselves. I know you can delete these measures but still sometimes things break if you just delete stuff...

By Viktoriia Shvydenko on 5/18/2021

I really enjoy this course. Having a clear problem statement in connection with each DAX solution makes learning easy and fun. I highly recommend this course to those who want to have more practice with DAX function.

By Hanna Lukashevich on 4/22/2021

Nice cource. It helped me to remined some DAX expressions in a short time. It is extremely usefull for newbies, due to lecturer gives information with simple practical examples.

Showing all 10 reviews on CourseDuck

Read all 1,228 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 84 / 100