Advanced DAX Queries
Become a DAX expert with our comprehensive, hands-on course designed to take you from beginner to pro in Power BI and DAX Studio.
4.9
(7 ratings)
Course Instructor
Parthiban Kannan
₹2000.00
/CourseBundles(51826)/3627281-Advanced_DAX_-_Tamil.png)
Master Advanced DAX Like a Pro!
Unlock the full potential of DAX with our world’s first Hybrid Course! Learn at your own pace with recorded lessons and get real-time guidance in live Q&A sessions.
Learn Advanced DAX Techniques
Dive deep into powerful DAX functions, calculations, and optimizations
Solve Real-World Business Problems
Apply DAX to real-world datasets and enhance your analytical skills.
Live Q&A with Experts
Get your doubts cleared instantly in interactive live sessions.
Dedicated Placement Support
Exclusive Career Guidance with Job & Internship Opportunities
Course Syllabus
1 Subject
Advanced DAX (Pre-Booking)
298 Learning Materials
Introduction to DAX & DAX Studio
Pre-requisites
Video
2:7
DAX Introduction
Video
3:30
DAX Studio - Introduction
Video
3:41
Course Data - AdventureWorks Sales - Microsoft
ZIP
Connecting to Power BI Data Model
Video
2:58
DAX Queries - Foundation
EVALUATE
Video
10:50
Query - EVALUATE
ZIP
ORDER BY
Video
5:17
Query - ORDER BY
ZIP
START AT
Video
8:13
Query - START AT
ZIP
ROW
Video
3:52
Query - ROW
ZIP
VAR - Introduction
Video
8:25
Query - VAR Introduction
ZIP
DEFINE VARIABLES
Video
7:22
Query - DEFINE VARIABLES
ZIP
DAX Operators
Arithmetic Operations
Video
12:40
Query - Arithmetic Operators
ZIP
Comparison Operators
Video
8:29
Query - Comparison Operators
ZIP
Text Concatenation Operator
Video
3:18
Query - Text Concatenation Operator
ZIP
Logical Operators
Video
23:30
Query - Logical Operators
ZIP
Table Manipulation Functions
Data for Table Manipulation
ZIP
Distinct Function
Video
2:34
Query - DISTINCT
ZIP
Add Columns
Video
11:44
Query - ADDCOLUMNS
ZIP
Generate Series
Video
2:6
Query - GENERATE SERIES
ZIP
Creating Data Table
Video
9:17
Query - DATATABLE
ZIP
Cross Join or Cartesian Join
Video
4:22
Query - CROSSJOIN
ZIP
Generate - Combining Tables based on LEFT Table
Video
8:7
Query - Generate
ZIP
Generate All
Video
2:17
Query - Generate All
ZIP
Natural Inner Join
Video
3:26
Query - Natural Inner Join
ZIP
Natural Left Outer Join
Video
2:38
Query - Natural Left Outer Join
ZIP
Summarize
Video
4:43
Query - Summarize
ZIP
Rollup
Video
4:59
Query - Rollup
ZIP
Rollup Group
Video
3:31
Query - Rollup Group
ZIP
Summarize Columns
Video
3:45
Query - Summarize Columns
ZIP
Rollup Add Is SubTotal
Video
4:6
Query - Rollup Add Is Subtotal
ZIP
Add Missing Items
Video
3:59
Query - Add Missing Items
ZIP
Rollup Is SubTotal
Video
5:46
Query - Rollup Is SubTotal
ZIP
SET Operations - Except, Union & Intersect
Video
14:8
Query - SET Operations - Except, Union & Intersect
ZIP
Top N
Video
7:48
Query - Top N
ZIP
Aggregate Functions
Practice Data for Aggregate Functions
ZIP
Count and CountX
Video
4:44
Query - Count and CountX
ZIP
CountA and CountAX
Video
3:7
Query - CountA and CountAX
ZIP
Counting Blank Values
Video
1:31
Query - Counting Blank Values
ZIP
Counting Rows
Video
1:2
Query - Counting Rows
ZIP
Counting Distinct Values
Video
2:44
Query - Counting Distinct Values
ZIP
Finding Minimum Values
Video
5:9
Query - Finding Minimum Values
ZIP
Finding Minimum Values with Expression
Video
1:32
Query - Finding Minimum Values with Expression
ZIP
Finding Maximum Values
Video
3:7
Query - Finding Maximum Values
ZIP
Sum Operations
Video
2:25
Query - SUM Operations
ZIP
Product Operations
Video
2:41
Query - Product Operations
ZIP
Average Function
Video
4:15
Query - Average Function
ZIP
Logical Function
Data For Logical Function
ZIP
AND Operation
Video
3:7
Query - AND Operation
ZIP
OR Operation
Video
2:16
Query - OR Operation
ZIP
NOT Operation
Video
1:24
Query - NOT Operation
ZIP
IF Condition
Video
4:53
Query - IF Condition
ZIP
True and False
Video
2:33
Query - True and False
ZIP
IF.Eager Function
Video
8:48
Query - IF.Eager Function
ZIP
If Error
Video
3:7
Query - If Error Function
ZIP
COALESCE Function
Video
4:51
Query - COALESCE Function
ZIP
Switch with Exact Match
Video
3:18
Query - Switch with Exact Match
ZIP
Switch with Numerical Value Comparison
Video
5:44
Query - Switch with Numerical Value Comparison
ZIP
Information Function
Data For Information Functions
ZIP
Analyze Column Statistics
Video
3:50
Query - COLUMNSTATISTICS
ZIP
Contains
Video
6:54
Query - CONTAINS()
ZIP
Contains ROW
Video
1:41
Query - CONTAINSROW
ZIP
Contains String
Video
6:00
Query - CONTAINSSTRING() & CONTAINSSTRINGEXACT()
ZIP
Filter and Slicer Simulation
Video
11:47
Query - Filter and Slicer Simulation
ZIP
Has One Filter
Video
9:7
Query - HASONEFILTER
ZIP
Has One Value
Video
1:27
Query - HASONEVALUE
ZIP
Check the Column has Applied Filters
Video
4:00
Query - ISFILTERED
ZIP
Check the Table Filtered by Other Tabular Column
Video
4:6
Query - ISCROSSFILTERED
ZIP
Text and Non-Text Values
Video
2:13
Query - ISTEXT() and ISNONTEXT()
ZIP
Number, Odd or Even
Video
3:10
Query - ISNUMBER, ISODD, ISEVEN
ZIP
Find Missing Values
Video
2:29
Query - ISBLANK
ZIP
Find Error Values
Video
2:13
Query - ISERROR
ZIP
Find out Logical Values
Video
1:29
Query - ISLOGICAL
ZIP
Find Empty Tables
Video
1:10
Query - ISEMPTY
ZIP
Find sub total rows
Video
3:9
Query - ISSUBTOTAL
ZIP
Find the scope of hierachy w.r.t rows
Video
3:50
Query - ISINSCOPE
ZIP
Math & Trig Functions
Data For Practice
ZIP
Division and Modulus
Video
3:15
Query - Divide and Modulus
ZIP
Ceiling and Floor
Video
2:43
Query - Ceiling and Floor
ZIP
Rounding
Video
3:21
Query - Rounding
ZIP
Rounding Up and Down
Video
1:59
Query - Rounding Up and Down
ZIP
Truncate
Video
1:13
Query - Truncate
ZIP
Rounding to Even
Video
1:2
Query - Rounding to Even
ZIP
Power
Video
1:28
Query - Power
ZIP
Square Root
Video
032
Query - SQRT
ZIP
Exponential Growth
Video
043
Query - Exponential Growth
ZIP
Sign and Absolute Value
Video
1:13
Query - Sign and Absolute Value
ZIP
Factorial
Video
1:16
Query - Factorial
ZIP
GCD & LCM
Video
1:57
Query - GCD & LCM
ZIP
Logarithm
Video
1:12
Query - Logarithm
ZIP
Text Functions
Data For Practice - Text Functions
ZIP
Concatenate and Combine Values
Video
8:24
Query - Concatenate and Combine Values
ZIP
ConcatenateX
Video
2:19
Query - CONCATENATEX
ZIP
Exact Comparison
Video
2:44
Query - EXACT
ZIP
Find and Search
Video
3:47
Query - Find and Search
ZIP
Fixed
Video
2:42
Query - FIXED
ZIP
Formatting Text
Video
6:37
Query - FORMAT
ZIP
VALUE
Video
2:36
Query - VALUE
ZIP
Left, Mid and Right Split
Video
3:11
Query - LEFT, MID and RIGHT
ZIP
Length of Text
Video
051
Query - LENGTH
ZIP
Trimming White Spaces on Prefix and Suffix
Video
3:4
Query - TRIM
ZIP
Replace and Substitute
Video
3:53
Query - REPLACE and SUBSTITUTE
ZIP
Upper and Lower Case Conversion
Video
1:14
Query - UPPER and LOWER
ZIP
Repeat Text
Video
1:8
Query - REPT
ZIP
Date & Time Functions
Practice Data for Date Time Functions
ZIP
Date and Time
Video
2:19
Query - DATE and TIME
ZIP
Calendar
Video
2:25
Query - Calendar
ZIP
Calendar Auto
Video
3:52
Query - Calendar Auto
ZIP
Date Difference
Video
3:3
Query - Date Difference
ZIP
Date Value
Video
1:17
Query - Date Value
ZIP
Date Extraction
Video
2:25
Query - Date Extraction
ZIP
EDate and EOMonth
Video
2:22
Query - EDate and EOMonth
ZIP
Total Working Days
Video
4:15
Query - NETWORKDAYS
ZIP
Current Values
Video
1:41
Query - Current Date and Time
ZIP
Week Day
Video
2:7
Query - Weekday
ZIP
Time Intelligence Functions
Data For Practice - Time Intelligence
ZIP
DateTable for Time Intelligence
Video
6:1
Query - DateTable for Time Intelligence
ZIP
Closing and Opening Balance of the Month
Video
7:2
Query - Closing and Opening Balance of the Month
ZIP
Closing and Opening Balance of the Quarter
Video
2:31
Query - Closing and Opening Balance of Quarter
ZIP
Closing and Opening Balance of the Year
Video
5:00
Query - Closing and Opening Balance of the Year
ZIP
Dates Between Two Given Dates
Video
1:47
Query - Dates Between
ZIP
Dates From a Given Date and A Period
Video
2:10
Query - DATESINPERIOD
ZIP
Shifting Dates Forward and Backward
Video
9:13
Query - DATESADD
ZIP
Start and End of Month
Video
3:37
Query - Start and End of Month
ZIP
Start and End of Quarter
Video
2:38
Query - Start and End of the Quarter
ZIP
Start and End of the Year
Video
2:35
Query - Start and End of the Year
ZIP
First and Last Date
Video
1:10
Query - First and Last Date
ZIP
Previous and Next
Video
6:3
Query - Previous and Next
ZIP
Same Period and Last Year
Video
2:6
Query - Same Period Last Year
ZIP
Parent & Child Functions
Practice Data
ZIP
Path
Video
2:15
Query - PATH
ZIP
Path Length
Video
1:25
Query - Path Length
ZIP
Path Item and Path Reverse Item
Video
3:27
Query - PATHITEM, PATHREVERSEITEM
ZIP
Path Contains
Video
1:26
Query - Path Contains
ZIP
Relationship Functions
Data for Practice - Relationship Functions
ZIP
Cross Filter
Video
7:41
Query - Cross Filter
ZIP
Cross Filter - OneWay Vs Both
Video
5:22
Query - ONEWAY, BOTH
ZIP
Related Column Values
Video
1:40
Query - RELATED
ZIP
Related Table Values
Video
4:36
Query - RELATED TABLE
ZIP
Use Relationship
Video
6:17
Query - Use Relationship
ZIP
Filter Functions
Data for Practice - Filter Functions
ZIP
Calculate
Video
3:50
Query - CALCULATE
ZIP
Treat As
Video
2:33
Query - TREATAS
ZIP
Calculate Table
Video
1:48
Query - CALCULATETABLE
ZIP
All Values From the Column or Table
Video
11:58
Query - ALL
ZIP
All Values Ignoring Cross Filters
Video
7:42
QUERY - ALLCROSSFILTERED
ZIP
All Except
Video
6:57
Query - ALLEXCEPT
ZIP
All Selected
Video
10:35
Query - ALLSELECTED
ZIP
All but No Blank Rows
Video
3:43
Query - ALLNOBLANKROWS
ZIP
Earlier
Video
7:57
Query - EARLIER / EARLIEST
ZIP
Filter Rows
Video
2:8
Query - FILTER
ZIP
Keep and Remove Filters
Video
7:14
Query - KEEPFILTERS, REMOVEFITLERS
ZIP
Lookup Value
Video
1:57
Query - LOOKUPVALUE
ZIP
Window Functions
Data For Practice - Window Functions
ZIP
Index
Video
8:52
Query - INDEX | ORDERBY | PARTITIONBY
ZIP
Offset
Video
5:12
Query - OFFSET | ORDERBY | PARTITIONBY
ZIP
Window
Video
6:17
Query - WINDOW | ORDERBY | PARTITIONBY
ZIP
Rank
Video
3:8
Query - RANK
ZIP
Acknowledgment Form
Acknowledgment Form
External Link
Real-Time Technical Support
Experience seamless technical support like never before with our dedicated Discord platform
Connect directly with trainer, fellow learners, and industry experts in real-time.
Why it works for you?
Our Advanced DAX program provides in-depth knowledge of each function using real-world datasets for practical understanding. Plus, our placement support helps you land your dream job.
Learn everything from foundational concepts to advanced techniques, giving you the skills to confidently write complex DAX queries in தமிழ் (Tamil) Language
Study at your own pace, anytime and anywhere, with lifetime access to recorded lessons and resources
We provide real-world practice datasets and queries, giving you hands-on experience to reinforce your learning and build confidence.
With our dedicated placement guidance, we support and refer committed students to secure their dream jobs.
Become a Confident Business Analyst!
Writing DAX queries is not simple, and that's why it's a primary requirement for many Business Analyst jobs.
Learning DAX in the right order helps you understand how to solve complex problems, and with out placement guidance you can easily reach your destination which is why you must take this course.
Ratings & Reviews
4.9 /5
7 ratings
●
6 reviews
5
86%
4
14%
3
0%
2
0%
1
0%
Frequently asked questions
Have questions? We’ve got you covered! Explore the most common queries about the course, from prerequisites to certification, and get all the details you need to start your journey toward mastering Advanced DAX.
Who is this course for?
This course is ideal for Business Analysts, Data Analysts, Power BI Developers and anyone looking to enhance their DAX skills and take their data analysis capabilities to the next level. Whether you're just starting out or have some experience, this course will help you master DAX at an advanced level.
Do I need prior knowledge of DAX to take this course?
While prior knowledge of Power BI concepts is mandatory, this course is designed to teach you everything you need to know to become an expert in DAX. We’ll cover everything from foundational concepts to advanced DAX techniques in a structured way. However, we are not covering Power BI concepts in this course.
Do I get Placement Support?
Yes! We are providing the dedicated placement support for this DAX course on the specific role of Power BI Developer, Data Analyst and Business Analyst roles. Also we provide you all the necessary placement preparation training to landing on your Dream JOB.
How can I clear my queries during the course?
You’ll have access to live Q&A sessions where you can ask questions and get expert answers in real-time. Additionally, you can reach out through Discord and get text and voice support.
How long will I have access to the course materials?
Once enrolled, you'll have lifetime access to all course materials, including recorded lessons, exercises, and any updates. You can learn at your own pace, whenever it fits your schedule.
Will I get a certificate after completing the course?
Yes, upon successful completion of the course, you’ll receive a certificate that showcases your mastery of advanced DAX techniques. This certificate can help boost your career prospects and demonstrate your skills to potential employers.
Is this course suitable for someone switching careers?
Absolutely! If you’re looking to transition into a data-focused role like Business Analyst or Data Analyst, this course provides the essential DAX knowledge and practical skills needed to excel in these positions.
How can I enroll in the course?
Simply click the “Enroll Now” button on this page to secure your spot. Once enrolled, you'll get instant access to all course materials!
By clicking on Continue, I accept the Terms & Conditions,
Privacy Policy & Refund Policy