This course will provide you with the knowledge and skills to write DAX expressions to aid the development of models within Power BI Desktop.
Delegates attending this course should have a thorough knowledge of Power BI Desktop. This can be gained by attending QAPBIDESK or QAPBIDT3.
Virtual Classroom
For learners attending remotely via any virtual classroom, an additional screen is required for this course to work through remote desktop labs and view training information. A remote Desktop will be provided using GoToMyPC or LearnOnDemand.
The additional screen must have a minimum screen size of 19 inch and minimum resolution of 1280x1024, with the vertical resolution (1024) being the most critical.
If you have questions,contact our Virtual team.
Module 1: Overview
This module provides essential background information on the use of DAX within Microsoft products. The module outlines the uses of DAX within the Power BI model for calculating columns, measures and tables
Lab :
Module 2: Basics and Aggregations
This module shows how to create basic calculations for columns and measures using DAX. The functions used in the module include SUMX, DISTINCTCOUNT, DIVIDE, CALCULATE, SUMMARIZE. VAR and RETURN are also used.
Lab :
Module 3: Working with dates and times
This module describes how to create a date / calendar table and the uses that table to create time intelligence calculations. The functions used in the module include CALENDAR, CALENDARAUTO, YEAR, MONTH, FORMAT, DATEDIFF, DATEADD, SAMEPERIODLASTYEAR, PARALLELPERIOD, ADDCOLUMNS, TOTALYTD, and DATESINPERIOD.
Lab A:
Lab B:
Module 4: Relational
This module describes how to use relational functions. The functions used in this module include RELATED, RELATEDTABLE, USERELATIONSHIP and LOOKUPVALUE.
Lab :
Module 5: Filtering
This module describes how to use various filtering functions to add intelligence to the measures within the Power BI Desktop model. The functions used in this module include ALL, ALLEXCEPT, ALLSELECTED, FILTER, HASONEVALUE, VALUES, SELECTEDVALUES, and ISFILTERED.
Lab :
Module 6: Ranking and Positional
This module describes how to TOPN and RANKX to calculate and present positional information.
Lab :
Module 7: Parent and Child
This module describes how to navigate and present a tree-structures parent and child table using Power BI Desktop and DAX. The module uses PATH, PATHITEM, PATHCONTAINS, PATHLENGTH and LOOKUPVALUE.
Lab :
Experience live, interactive learning from the comfort of your home or office with Bilginç IT Academy's Online Instructor-Led Using DAX in Power BI Training in South Africa. Engage directly with expert trainers in a virtual environment that mirrors the energy and schedule of a physical classroom.
Immerse yourself in our most sought-after learning style for Using DAX in Power BI Training in South Africa. Our hand-picked classroom venues in South Africa offer an invaluable human touch, providing a focused and interactive environment for professional growth.
Streamline your organization's training requirements with Bilginc IT Academy’s Onsite Using DAX in Power BI Training in South Africa. Experience expert-led learning at your own business premises, tailored to your corporate goals.
Join our public courses in our South Africa facilities. Private class trainings will be organized at the location of your preference, according to your schedule.
South Africa is the most advanced technological market on the continent, with Cape Town and Johannesburg acting as world-class centers for fintech, telecommunications, and digital entrepreneurship. Cape Town’s vibrant tech scene, often called 'Silicon Cape,' attracts international venture capital and research talent, while Johannesburg remains the industrial and financial heart of technical innovation. The country's top universities, including the University of Cape Town and Wits, provide a strong academic foundation for research in Artificial Intelligence and Big Data. Our educational frameworks in South Africa focus on equipping the professional workforce with the high-level skills needed to manage complex enterprise infrastructures. We provide elite training in Cybersecurity, Enterprise Architecture, and Data Science to support South Africa's leading role in the global digital economy.
