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 France. 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 France. Our hand-picked classroom venues in France 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 France. Experience expert-led learning at your own business premises, tailored to your corporate goals.
Join our public courses in our France facilities. Private class trainings will be organized at the location of your preference, according to your schedule.
France stands as a cornerstone of European industrial innovation, with Paris and Lyon serving as premier global hubs for aerospace, automotive technology, and high-end digital startups. The French tech ecosystem, famously supported by the 'La French Tech' initiative, thrives on the research excellence of institutions like Sorbonne University and École Polytechnique. As a leader in sustainable energy software and sophisticated telecommunications, France offers a highly competitive landscape for advanced professional development. Our IT training programs in France are designed to meet these elite standards, focusing on Cloud Computing, Cybersecurity, and Data Science certifications. We empower professionals across the Republic to lead digital transformation projects within a diverse economy that is consistently pushing the boundaries of engineering and artificial intelligence.
