Create Model Calculations by Using DAX from Pluralsight

The DAX modeling language allows complete control over the data in your visuals in Power BI. This course will teach you how to create new measures that filter and aggregate data in ways that are impossible without DAX.

The DAX modeling language allows for calculations in Power BI that are otherwise impossible using calculated columns and quick measures. In this course, Create Model Calculations by Using DAX, you’ll learn to enhance your Power BI reports with measures that can solve new problems like percentage of total calculations and end-of-quarter balances. First, you’ll explore how to replace existing measures with new DAX measures. Next, you’ll discover the CALCULATE formula, which will allow you to add and remove filters on your Power BI visuals. Finally, you’ll learn how to build measures that aggregate values over different time periods. When you’re finished with this course, you’ll have the skills and knowledge of the DAX modeling language needed to create advanced calculations in Power BI.

What's inside

Syllabus

Course Overview

Enhance Reports Using Measures

Using the CALCULATE() Function to Modify Measures

Build Time Intelligence Measures with DAX

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Teaches essential DAX modeling in a straightforward manner

Covers fundamentals of DAX modeling in Power BI

Suitable for intermediate Power BI users seeking to enhance data modeling skills

Demonstrates practical applications of DAX modeling for data analysis

Empowers learners to create advanced calculations and solve complex data analysis problems

Reinforces learning through hands-on exercises and examples

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Create Model Calculations by Using DAX with these activities:

Learn DAX basics

Show steps

Solidify your foundational skills in DAX to prepare for this course's content

Browse courses on DAX

Show steps

Review DAX documentation
Complete online tutorials on DAX fundamentals
Practice writing basic DAX expressions

Read "DAX Patterns"

Show steps

Gain insights into best practices and patterns for effective DAX use

View DAX Patterns: Second Edition on Amazon

Show steps

Read the book and take notes
Apply the patterns and techniques in your own DAX projects

Follow DAX tutorials

Show steps

Expand your knowledge of DAX by following guided tutorials

Browse courses on DAX

Show steps

Search for DAX tutorials on YouTube or online platforms
Follow along with the tutorials and practice the exercises
Ask questions in the tutorial forums or online communities

Five other activities

Expand to see all activities and additional details

Show all eight activities

Practice DAX exercises

Show steps

Reinforce your understanding of DAX through repetitive exercises

Browse courses on DAX

Show steps

Solve DAX practice problems from online resources
Create DAX measures for sample datasets
Participate in online DAX challenges

Join a DAX study group

Show steps

Collaborate with peers to enhance your DAX knowledge

Browse courses on DAX

Show steps

Find a study group or create your own
Meet regularly to discuss DAX concepts and solve problems
Share resources and support each other's learning

Develop a DAX solution for a business problem

Show steps

Apply your DAX skills to solve real-world business problems

Browse courses on DAX

Show steps

Identify a business problem that can be solved with DAX
Design and implement a DAX solution
Test and refine your solution
Present your solution to others

Contribute to open-source DAX projects

Show steps

Gain practical experience and contribute to the DAX community

Browse courses on DAX

Show steps

Identify open-source DAX projects on GitHub or other platforms
Review the codebase and identify areas where you can contribute
Submit pull requests with your contributions
Collaborate with other contributors to refine your contributions

Mentor junior DAX users

Show steps

Reinforce your knowledge by teaching others and giving back to the community

Browse courses on DAX

Show steps

Identify opportunities to mentor junior DAX users
Provide guidance and support on DAX concepts and techniques
Review their work and offer constructive feedback
Encourage them to ask questions and explore new ideas

Career center

Learners who complete Create Model Calculations by Using DAX will develop knowledge and skills that may be useful to these careers:

Data Analyst

Data Analysts use their training in computer programming, statistics, and mathematics to perform complex data analysis, which can include analyzing business data, generating reports, and designing data visualizations. With the knowledge that you will learn in Create Model Calculations by Using DAX, you will be able to efficiently model data in Power BI to solve complex problems, which will benefit your career as a Data Analyst.

See salaries and explore the career path for Data Analyst

Business Analyst

Business Analysts implement solutions to improve business processes and increase profits. They are trained in data analysis, modeling, and forecasting. The skills that you will learn from Create Model Calculations by Using DAX can help you design and implement data-driven solutions to business problems, which will help you succeed as a Business Analyst.

See salaries and explore the career path for Business Analyst

Financial Analyst

Financial Analysts interpret and communicate financial information to business professionals or individual investors. They use data analysis to make investment recommendations, forecast revenue, and evaluate the financial performance of companies.

See salaries and explore the career path for Financial Analyst

Market Researcher

Market Researchers collect, analyze, and interpret market data to understand customers and their needs. They use this information to develop marketing strategies and campaigns. With the skills from this course, you will be able to analyze market data using advanced techniques in DAX to gain insights and create effective marketing strategies.

See salaries and explore the career path for Market Researcher

Data Scientist

Data Scientists use scientific methods, processes, algorithms, and systems to extract knowledge and insights from data in various forms, both structured and unstructured. The knowledge you will learn in Create Model Calculations by Using DAX will be helpful to you as a Data Scientist, because it will enable you to create advanced data models and perform complex data analysis.

See salaries and explore the career path for Data Scientist

Operations Research Analyst

Operations Research Analysts apply advanced analytical techniques to help organizations improve their decision-making processes. They use mathematical modeling, simulation, and data analysis to solve complex problems related to resource allocation, supply chain management, and logistics.

See salaries and explore the career path for Operations Research Analyst

Management Consultant

Management Consultants help organizations improve their performance by analyzing their business processes and identifying areas for improvement. They use data analysis and modeling to develop and implement solutions to business problems. As a Management Consultant, you can leverage the skills gained in Create Model Calculations by Using DAX to perform advanced data analysis and develop data-driven solutions.

See salaries and explore the career path for Management Consultant

Financial Planner

Financial Planners help individuals and families plan and manage their finances. They analyze financial data and create financial plans to help clients achieve their financial goals. The skills that you will learn in Create Model Calculations by Using DAX will allow you to create advanced financial models and provide better financial advice to your clients.

See salaries and explore the career path for Financial Planner

Actuary

Actuaries use mathematical and statistical techniques to assess risk and uncertainty. They work in a variety of industries, including insurance, finance, and healthcare. The knowledge that you will gain in Create Model Calculations by Using DAX will be useful in your career as an Actuary, because it will allow you to create sophisticated financial models and analyze risk.

See salaries and explore the career path for Actuary

Statistician

Statisticians collect, analyze, interpret, and present data. They use statistical methods to solve problems in a variety of fields, including healthcare, finance, and marketing. The skills you will learn from Create Model Calculations by Using DAX will be helpful in your career as a Statistician, as they will enable you to perform advanced data analysis and develop statistical models.

See salaries and explore the career path for Statistician

Software Engineer

Software Engineers design, develop, and maintain software applications. They use a variety of programming languages and technologies to create software that meets the needs of users. The skills that you will learn in Create Model Calculations by Using DAX will be useful to you as a Software Engineer, as they will enable you to develop data-driven applications.

See salaries and explore the career path for Software Engineer

Data Engineer

Data Engineers design, build, and maintain data pipelines and infrastructure. They use a variety of tools and technologies to ensure that data is clean, consistent, and accessible to users. The knowledge that you will gain in Create Model Calculations by Using DAX will be useful in your career as a Data Engineer, as it will allow you to create data models and develop data pipelines.

See salaries and explore the career path for Data Engineer

Database Administrator

Database Administrators maintain and optimize databases. They ensure that data is stored and retrieved efficiently and securely. The skills that you will learn in Create Model Calculations by Using DAX will be useful to you as a Database Administrator, as they will enable you to create and manage data models.

See salaries and explore the career path for Database Administrator

Information Security Analyst

Information Security Analysts plan and implement security measures to protect information systems from unauthorized access, use, disclosure, disruption, modification, or destruction. The knowledge that you will gain in Create Model Calculations by Using DAX will be useful in your career as an Information Security Analyst, as it will enable you to analyze data and identify security risks.

See salaries and explore the career path for Information Security Analyst

IT Auditor

IT Auditors evaluate the security and effectiveness of an organization's IT systems. They use a variety of techniques to identify risks and vulnerabilities. The skills that you will learn in Create Model Calculations by Using DAX will be useful to you as an IT Auditor, as they will enable you to analyze data and identify IT risks.

See salaries and explore the career path for IT Auditor