Power BI DAX Video Course – Basic to Advanced (17+ Hours + 3 Advanced Projects + Scenario Based QnA)

By Swapnjeet S – Data Tutorials

Master Power BI DAX from fundamentals to expert-level analytics with this complete 17+ hour video course. Learn all DAX functions, build complex calculations, and apply them in real business scenarios. Includes 3 full end-to-end Advanced Projects + Real-Time Scenario-Based Interview QnA to make you job-ready.

Complete Syllabus (Numbered Modules + All Functions in Single Lines)

1. DAX Introduction

Concepts of DAX, Row Context, Filter Context, Context Transition, Evaluation Flow, Variables (VAR/RETURN), Measures vs Calculated Columns.

2. Aggregate Functions

SUM, SUMX, AVERAGE, AVERAGEX, COUNT, COUNTX, COUNTA, DISTINCTCOUNT, MIN, MINX, MAX, MAXX, PRODUCTX

3. Logical Functions

IF, AND, OR, NOT, SWITCH, TRUE, FALSE, COALESCE, IFERROR

4. Date & Time Functions

DATE, DATEVALUE, DATEDIFF, EDATE, EOMONTH, YEAR, MONTH, DAY, WEEKDAY, WEEKNUM, TODAY, NOW, TIME, HOUR, MINUTE, SECOND

5. Time Intelligence Functions

DATESYTD, SAMEPERIODLASTYEAR, DATEADD, PARALLELPERIOD, TOTALYTD, TOTALMTD, TOTALQTD, PREVIOUSYEAR, PREVIOUSMONTH, PREVIOUSQUARTER, PREVIOUSWEEK, NEXTYEAR, NEXTMONTH, NEXTQUARTER, NEXTWEEK, NEXTDAY, STARTOFYEAR, STARTOFMONTH, STARTOFQUARTER, STARTOFWEEK, ENDOFYEAR, ENDOFMONTH, ENDOFQUARTER, ENDOFWEEK, FIRSTDATE, LASTDATE, DATESBETWEEN, DATESINPERIOD, DATESMTD, DATESQTD, DATESWTD, TOTALWTD

6. Filter & Context Functions

CALCULATE, CALCULATETABLE, FILTER, ALL, ALLSELECTED, ALLEXCEPT, ALLCROSSFILTERED, ALLNOBLANKROW, REMOVEFILTERS, KEEPFILTERS, EARLIER, EARLIEST, SELECTEDVALUE, VALUES, DISTINCT, LOOKUPVALUE, LOOKUP, LOOKUPWITHTOTALS, OFFSET, INDEX, MATCHBY, RANK, ROWNUMBER, MOVINGAVERAGE, PARTITIONBY, ORDERBY, WINDOW, RUNNINGSUM

7. Text Functions

CONCATENATE, CONCATENATEX, LEFT, RIGHT, MID, LEN, TRIM, SUBSTITUTE, REPLACE, FIND, SEARCH, LOWER, UPPER, FORMAT

8. Relationship Functions

RELATED, RELATEDTABLE, USERELATIONSHIP, CROSSFILTER, PATH, PATHCONTAINS, PATHITEM, PATHITEMREVERSE, PATHLENGTH

9. Other Essential Functions

DIVIDE, BLANK, ISBLANK, ISFILTERED, HASONEVALUE, ISINSCOPE, RANKX, ERROR, GROUPBY

10. Advanced Real-World Projects (Start to End)

11. Real-Time Scenario-Based Interview QnA

Includes expert-level DAX scenarios on:

Why Should You Purchase This Course? (Powerful Selling Points)

✅ Learn ALL DAX functions — not just basics

Includes every single commonly used + advanced DAX function in one structured course.

✅ Perfect for beginners AND working professionals

Start from fundamentals → build mastery → solve real-world problems like a Senior Data Analyst.

✅ 17+ hours of high-quality, practical video content

Not theory — pure implementation, case studies, and industry examples.

✅ 3 End-to-End Projects

Experience real dashboard development with advanced DAX – exactly what companies expect.

✅ Job-Focused Interview QnA Included

Covers real scenarios asked in interviews for Data Analyst, BI Analyst & Power BI Developer roles.

✅ Made by Swapnjeet S (Data Tutorials)

Trusted by thousands of learners, clear teaching style, practical explanations, real industry expertise.

✅ You will become the “DAX Expert” in your team

After this course, you will write cleaner, faster, optimized, production-grade DAX.

📞 For Support or Queries

📧 Email: [email protected]

📱 WhatsApp: +91 9579005495