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 Using DAX in Power BI in Bahrain through Bilginç IT Academy's live and interactive virtual classroom environment, accessible from your home, office, or any location. Connect with expert trainers in real time and bring the energy of classroom learning into the digital experience.
Experience Using DAX in Power BI in a focused classroom environment in Bahrain. Bilginç IT Academy's carefully selected training venues provide a professional setting where delegates can interact directly with expert trainers and peers.
Meet your team's training needs with Bilginç IT Academy's onsite Using DAX in Power BI in Bahrain solution, delivered at your office or preferred location. Align your team's development with your business goals through a training experience tailored to your organization.
Join our public courses in our Bahrain facilities. Private class trainings will be organized at the location of your preference, according to your schedule.
Bahrain has positioned itself as the pioneering fintech and cloud capital of the Middle East, with Manama hosting the region’s first dedicated fintech hub, Bahrain FinTech Bay. As the first country in the region to adopt a 'Cloud First' policy, Bahrain has attracted global giants like AWS to establish massive data center infrastructures on its shores. The University of Bahrain and various national initiatives are focused on cultivating a workforce that is highly proficient in blockchain, open banking, and cybersecurity. Our IT education services in Bahrain are tailored to this innovation-driven market, offering advanced curriculum in Cloud Engineering, DevOps, and Information Security. We empower professionals in the Kingdom to take the lead in a digital-first economy that consistently sets the benchmark for regulatory technology and financial innovation across the Gulf.
