Course Information
Course Overview
Complete tutorial on DAX in Power BI
How to use RANKX - its fundamentals with challenges
Which one better - Calculated column DAX or Measure DAX - with scenarios
Learn about HASONEVALUE - From functioning to practical use
Get ready for Surprise Tests also - See how well you are doing.
Related DAX - Vlookup way
All great Time Intelligence DAX functions
Comparison of performance over the years, months,quarters
Cumulative SUMs - yearly, monthy , daily
Why we should know SUMMARIZE Dax
CALCULATETABLE Dax and its use with Summarize dax
Powerful Dax - Selected Value
Course Content
- 1 section(s)
- 25 lecture(s)
- Section 1 Introduction
What You’ll Learn
- In this Part2 , We are learning more Dax functions and more fundamentals.
- RANKX , SELECTED VALUE, HASONEVALUE,RELATED DAX,SUMMARIZE,CALCULATETABLE,EARLIER etc
- Where and when we use MEASURES and CALCULATED COLUMNS - Detailed discussion
- Time Intelligence DAX Functions and practical use with exercises.
- How to get cumulative totals
- how to do month on month comparisons
- how to do year on year or quarter to quarter Comparisons using Time Intelligence functions.
- How to find Top performances or bottom performances.
- How to use other table fields in main table using DAX Measure or Calculated Columns - Quiz for you
Skills covered in this course
Reviews
-
TTayfun Senturk
That is the beast teacher ı have ever seen.You should buy all the courses
-
KKim Mamula
REVISED REVIEW: Ajay was very responsive to the issues that I raised in my first review. Not only did he respond, but he even created additional lectures. I changed my review based on this. Original Review +++++++++++++++++ Part 1 of this course was so good that I definitely wanted to do Part 2. Part 2 was not put together nearly as well as Part 1. Course resources were missing or were wrong, videos seem to have been missing portions, and some courses were just hard to follow (did not flow very well at all which made it confusing). There are also a lot more functions that this could have covered to make it more thorough. Disappointing.
-
PPavan Kumar
Best course available for DAX in Power BI on Udemy. Pleasant experience while learning, I can say that I've Intermediate DAX knowledge before enrolling to the course but now I can say I'm an expert in DAX. Thanks Ajay for all the effort in making this beautiful course.
-
NNittala subba Rao
JUST AWESOME SIR ...THEY WILL CHARGE ATLEAST 30K FOR ALL THE DAX COURSES ..BUT YOU ARE GIVING THE KNOWLEDGE BETTER THAN THEM ..THANK YOU SO MUCH SIR ..YOU ARE BEST TEACHER .. WAS STRUGGLING WITH UNDERSTANDING "FILTER CONTEXT" ..FINALLY YOUR VIDEOS ARE GOD GIFT ..PLEASE SIR DISCUSS ABOUT lIST.GENETATE OR ACCUMULATE FUNCTION IN MCODE