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 Sweden. 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 Sweden. Our hand-picked classroom venues in Sweden offer an invaluable human touch, providing a focused and interactive environment for professional growth.
Streamline your organization's training requirements with Bilginç IT Academy’s Onsite Using DAX in Power BI Training in Sweden. Experience expert-led learning at your own business premises, tailored to your corporate goals.
Join our public courses in our Sweden facilities. Private class trainings will be organized at the location of your preference, according to your schedule.
Sweden is the historic birthplace of global technology legends like Spotify and Ericsson, maintaining its status as a world leader in software engineering and sustainable digital solutions. Stockholm and Gothenburg serve as premier destinations for innovation, fueled by the academic prestige of KTH Royal Institute of Technology and a culture that embraces early technological adoption. The Swedish tech scene is characterized by its leadership in game development, green-tech, and secure communication systems, fostering a highly collaborative and creative professional environment. Our IT training programs in Sweden are tailored to this culture of excellence, focusing on Software Architecture, Cloud-Native development, and Cyber Defense. We support the Swedish workforce in maintaining their competitive edge within a Nordic region that consistently sets the global benchmark for digital integration and social innovation.
