Microsoft Power BI DAX Training Course
Learn the fundamentals of DAX on our One-Day Course - login from home
Learn the fundamentals of DAX on our One-Day Course - login from home
4.77
In order to take your modelling ability to the next level, it's essential to have a solid understanding of the DAX language. While it's possible to achieve a lot without DAX knowledge, delving into this language will unlock a whole new level of capabilities and insights. Our comprehensive one-day course builds on the knowledge our students have already learnt through the beginner, intermediate, and advanced Power BI courses, and introduces key concepts of DAX as well as guiding them through practical exercises on how to write DAX formulas. You will learn:
Strong Power BI Desktop skills, basic DAX and data modelling knowledge, with Power BI Advanced course completion recommended. Advanced Excel skills preferred.
Take this course as part of the PL-300 Power BI Certification pathway:
PL-300 Power BI Certification
Power BI BeginnerLearn to use Power BI to create interactive dashboards, custom reports, analyse data and share insights.
Power BI IntermediateLearn to build data models and calculations to produce intelligent dashboards. Remote training.
Power BI AdvancedAdvance your Power BI skills by learning DAX; Row Context, Functions, Calculated Columns, Measures and more.
Power BI Desktop Advanced ReportingMaster advanced Power BI reporting techniques in 1 day. Learn to create complex, layered, and interactive reports with custom visuals and navigation controls.
Power BI Data Transformation using Power QueryLearn Power Query for Excel and Power BI Desktop in 1 day. Master data transformation, query management, and M code to optimise your data workflows.
Data Visualisation with Power BI DesktopLearn to create visualisations and reports in Power BI Desktop in 1 day. Master data modelling, visualisation techniques, and report sharing.
DA-100 Power BI Certification
Become a Microsoft Power BI certified expert in Hong Kong. Attend our Nexacu Power BI courses, sit the DA-100 exam and become certified!
HK$12,870
Course Introduction
What is DAX
DAX Functions
DAX Contexts
DAX efficiency
DAX references
DAX best practices
Recap of Contexts
Introduction to Contexts
Recap of DAX Contexts
The Row Context
The Filter Context
The CALCULATE function
Context Transition
Contexts in Calculated Columns
Introduction to Columns
Row Context in Calculated Columns
Filter Context in Calculated Columns
Relationships in Row Contexts
The RELATED function
The RELATEDTABLE function
Using RELATEDTABLE in a column
The LOOKUPVALUE function
Row Contexts in Measures
Introduction to Row Contexts
Row Contexts in Measures
Simple iterator in a measure
Row Context and a related table
Functions and FILTER
Introduction to DAX functions
Time Intelligence functions
Date (Dimension) tables
Using date modifier DATESYTD
Simple filter expression
The value of VALUES
Table Functions
Introduction to Table functions
Using SUMMARIZECOLUMNS
Extended Topics
A join on unrelated tables – TREATAS
Ranking
Introduction to Ranking
Arguments in RANKX
What is Power BI?
Power BI is Microsoft’s business intelligence and data visualisation platform. It helps users connect to data, clean and transform datasets, build reports, create dashboards and share insights across an organisation.
What Power BI courses does Nexacu offer?
Nexacu offers Power BI Beginner, Power BI Intermediate, Power BI Advanced, Power BI DAX, Data Transformation with Power Query, Power BI Desktop Advanced Reporting, Data Visualisation with Power BI Desktop and PL-300 Power BI Certification.
Which Power BI course should I start with?
If you are new to Power BI, start with Power BI Beginner. If you already understand the basics, Power BI Intermediate is a suitable next step. More experienced users may choose Power BI Advanced, Power BI DAX, Data Transformation with Power Query or Power BI Desktop Advanced Reporting, depending on their goals.
Are Power BI courses suitable for beginners?
Yes. Power BI Beginner is designed for people who are new to Power BI and want to learn how to create reports, dashboards and visualisations. Basic confidence working with data, especially in Excel, is helpful.
What will I learn in Power BI training?
Depending on the course level, you may learn how to connect to data, transform data with Power Query, create data models, build visualisations, design dashboards, write DAX measures, manage filters, publish reports and share insights through the Power BI service.
Is Power BI training relevant for workplace reporting?
Yes. Nexacu’s Power BI courses are designed around practical workplace reporting and business intelligence tasks, including interactive dashboards, data models, automated reporting, DAX calculations, Power Query transformations and shared reports.
How difficult is Power BI to learn?
Power BI is accessible for beginners, but the difficulty depends on your experience with data, Excel, reporting and business intelligence concepts. Most learners start with the basics, then progress into data modelling, Power Query, DAX and advanced reporting as their needs grow.
Do I need Excel experience before learning Power BI?
Excel experience is helpful, especially if you work with spreadsheets, tables, PivotTables, charts or business data. It is not always required, but basic data confidence will help you get more from Power BI training.
Does Power BI training include DAX?
Yes. DAX is introduced in some Power BI courses and covered in more depth in Power BI Advanced and Power BI DAX. Learners who need stronger calculation, measure and modelling skills should consider the dedicated Power BI DAX course.
Does Power BI training include Power Query?
Yes. Power Query is included in relevant Power BI courses and covered in detail in Data Transformation with Power Query. This course is useful for learners who need to clean, reshape, combine and prepare data before reporting.
Can I attend Power BI training online?
Yes. Nexacu offers live online Power BI training through Remote East and Remote West sessions. Remote courses are instructor-led, so participants can ask questions, join discussions, complete exercises and receive trainer support during the class.
Is Power BI training available for corporate teams?
Yes. Nexacu provides Power BI corporate training for teams and organisations that need consistent skills in reporting, dashboards, data modelling, DAX, Power Query and business intelligence workflows.
Is PL-300 Power BI Certification available?
Yes. Nexacu offers PL-300 Power BI Certification as part of its Power BI course pathway. This pathway is suitable for learners who want to develop broader Power BI capability and prepare for Microsoft Power BI certification.
How many students are typically in a Power BI course?
Class sizes vary by session, but Nexacu generally keeps Power BI classes small so participants can ask questions, take part in discussion and receive trainer support throughout the course.
Will I receive a certificate after completing Power BI training?
Yes. Participants receive a certificate of completion, which can be added to a resumé or LinkedIn profile to acknowledge their Power BI training.
Power BI BeginnerLearn to use Power BI to create interactive dashboards, custom reports, analyse data and share insights.
Power BI IntermediateLearn to build data models and calculations to produce intelligent dashboards. Remote training.
Power BI AdvancedAdvance your Power BI skills by learning DAX; Row Context, Functions, Calculated Columns, Measures and more.
Power BI Desktop Advanced ReportingMaster advanced Power BI reporting techniques in 1 day. Learn to create complex, layered, and interactive reports with custom visuals and navigation controls.
Power BI Data Transformation using Power QueryLearn Power Query for Excel and Power BI Desktop in 1 day. Master data transformation, query management, and M code to optimise your data workflows.
Data Visualisation with Power BI DesktopLearn to create visualisations and reports in Power BI Desktop in 1 day. Master data modelling, visualisation techniques, and report sharing.
DA-100 Power BI Certification
Become a Microsoft Power BI certified expert in Hong Kong. Attend our Nexacu Power BI courses, sit the DA-100 exam and become certified!
HK$12,870
At Nexacu, we are proud to be the trusted training partner for hundreds of leading organisations across Australia, New Zealand, and around the world. From government agencies to multinational corporations, we help teams build practical skills and achieve real outcomes through expert-led training.
Students
4 & 5 Star Reviews
Google Reviews
Businesses Trust Nexacu
Custom workbook included with a step by step exercises
Learn with expert instructors, wherever you are
Valued by Individuals
Australia
New Zealand
Singapore
Malaysia
Philippines
Thailand
Indonesia