We may earn an affiliate commission when you visit our partners.
Brent Allen
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.
Read more
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.
Read more
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 Measures by Using DAX with Power BI, you’ll learn to enhance your Power BI reports with measures that can solve new problems like multiplying columns, end of month balance, and percentage of total calculations. First, you’ll explore how to build new calculations using DAX. Next, you’ll discover the CALCULATE formula, which will allow you to manipulate the filters on your Power BI visuals. Finally, you’ll learn how to build measures that span multiple time periods or provide end of period calculations. 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.
Register for this course and see more details by visiting:
OpenCourser.com/course/qkgzbm/create
What's inside
Syllabus
Course Overview
Enhance Reports Using Measures
Using the CALCULATE() Function to Modify Measures
Build Time Intelligence Measures with DAX
Read more
Syllabus
Course Overview
Enhance Reports Using Measures
Using the CALCULATE() Function to Modify Measures
Build Time Intelligence Measures with DAX
Read more
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Introduces calculations in Power BI that are otherwise impossible using other available functions
Taught by industry-recognized instructor Brent Allen
Covers the CALCULATE formula, which enables advanced data manipulation within Power BI visuals
Suitable for learners seeking to enhance their Power BI reports with advanced calculations
Builds foundations for learners new to DAX and strengthens existing knowledge for intermediate learners
May require prior experience with Power BI and data analysis concepts
Save this course
Save Create Measures by Using DAX with Power BI to your list so you can find it easily later:
Save
Save
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 Measures by Using DAX with Power BI with these
activities:
Read Pro DAX
Show steps
Expand your knowledge of DAX by reading chapters relevant to the course topics.
View
Analyzing Data with Microsoft Power BI and...
on Amazon
Show steps
-
Identify chapters that cover concepts such as CALCULATE(), time intelligence, and advanced measures.
-
Read the selected chapters and take notes.
-
Apply the concepts you learn to your own DAX projects and assignments.
Explore DAX CALCULATE() Function
Show steps
Deepen your understanding of the CALCULATE() function to manipulate filters and enhance your measures.
Show steps
-
Follow online tutorials on the CALCULATE() function.
-
Experiment with different filter arguments to modify measures.
-
Apply the CALCULATE() function to solve practical data manipulation problems.
Collaborate on DAX Projects
Show steps
Enhance your understanding by working with peers to solve DAX challenges and review each other's solutions.
Show steps
-
Join or create a study group with other students taking the course.
-
Work together on practice problems and assignments.
-
Provide feedback and critique on each other's DAX measures and solutions.
Four other activities
Expand to see all activities and additional details
Show all seven activities
Practice Time Intelligence Calculations
Show steps
Master time intelligence calculations in DAX by solving practice problems.
Show steps
-
Find online exercises or challenges for DAX time intelligence.
-
Solve problems involving end-of-period calculations, rolling averages, and year-over-year comparisons.
-
Discuss solutions and compare approaches with peers or online forums.
Contribute to DAX Open-Source Projects
Show steps
Deepen your understanding of DAX by contributing to open-source projects and interacting with the community.
Show steps
-
Identify open-source DAX projects on platforms like GitHub.
-
Review the project's documentation and contribution guidelines.
-
Make a contribution, such as fixing bugs, adding features, or improving documentation.
-
Engage with the project maintainers and community members.
Develop Advanced DAX Measure
Show steps
Apply your DAX skills to create a complex measure that solves a specific business problem.
Show steps
-
Identify a business scenario where an advanced DAX measure can provide valuable insights.
-
Design the measure using DAX functions and logic.
-
Implement the measure in Power BI and test its functionality.
-
Present the measure to stakeholders and explain its benefits.
Develop a Power BI Dashboard with Advanced DAX Measures
Show steps
Showcase your DAX skills by developing a comprehensive Power BI dashboard that utilizes advanced measures.
Show steps
-
Define the business problem and identify key performance indicators (KPIs).
-
Design the dashboard layout and visualizations.
-
Implement DAX measures to calculate and present the KPIs.
-
Test and refine the dashboard's performance and functionality.
-
Present the dashboard and demonstrate its value to stakeholders.
Read Pro DAX
Show steps
Expand your knowledge of DAX by reading chapters relevant to the course topics.
View
Analyzing Data with Microsoft Power BI and...
on Amazon
Show steps
Show steps
Show steps
- Identify chapters that cover concepts such as CALCULATE(), time intelligence, and advanced measures.
- Read the selected chapters and take notes.
- Apply the concepts you learn to your own DAX projects and assignments.
Explore DAX CALCULATE() Function
Show steps
Deepen your understanding of the CALCULATE() function to manipulate filters and enhance your measures.
Show steps
Show steps
Show steps
- Follow online tutorials on the CALCULATE() function.
- Experiment with different filter arguments to modify measures.
- Apply the CALCULATE() function to solve practical data manipulation problems.
Collaborate on DAX Projects
Show steps
Enhance your understanding by working with peers to solve DAX challenges and review each other's solutions.
Show steps
Show steps
Show steps
- Join or create a study group with other students taking the course.
- Work together on practice problems and assignments.
- Provide feedback and critique on each other's DAX measures and solutions.
Four other activities
Expand to see all activities and additional details
Show all seven activities
Practice Time Intelligence Calculations
Show steps
Master time intelligence calculations in DAX by solving practice problems.
Show steps
Show steps
Show steps
- Find online exercises or challenges for DAX time intelligence.
- Solve problems involving end-of-period calculations, rolling averages, and year-over-year comparisons.
- Discuss solutions and compare approaches with peers or online forums.
Contribute to DAX Open-Source Projects
Show steps
Deepen your understanding of DAX by contributing to open-source projects and interacting with the community.
Show steps
Show steps
Show steps
- Identify open-source DAX projects on platforms like GitHub.
- Review the project's documentation and contribution guidelines.
- Make a contribution, such as fixing bugs, adding features, or improving documentation.
- Engage with the project maintainers and community members.
Develop Advanced DAX Measure
Show steps
Apply your DAX skills to create a complex measure that solves a specific business problem.
Show steps
Show steps
Show steps
- Identify a business scenario where an advanced DAX measure can provide valuable insights.
- Design the measure using DAX functions and logic.
- Implement the measure in Power BI and test its functionality.
- Present the measure to stakeholders and explain its benefits.
Develop a Power BI Dashboard with Advanced DAX Measures
Show steps
Showcase your DAX skills by developing a comprehensive Power BI dashboard that utilizes advanced measures.
Show steps
Show steps
Show steps
- Define the business problem and identify key performance indicators (KPIs).
- Design the dashboard layout and visualizations.
- Implement DAX measures to calculate and present the KPIs.
- Test and refine the dashboard's performance and functionality.
- Present the dashboard and demonstrate its value to stakeholders.
Career center
Learners who complete Create Measures by Using DAX with Power BI will develop knowledge and skills
that may be useful to these careers:
Power BI Developer
Power BI Developer
The DAX modeling language is essential for Power BI Developers. In this course, you will learn to enhance your Power BI reports with measures that can solve new problems. You will also learn how to manipulate the filters on your Power BI visuals to get the data you need. Finally, you’ll learn how to build measures that span multiple time periods or provide end of period calculations.
Data Analyst
Data Analyst
The DAX modeling language allows for calculations in Power BI that are otherwise impossible using calculated columns and quick measures. Data Analysts need to be comfortable doing this type of calculation. In this course, you will learn to enhance your Power BI reports with measures that can solve new problems. You will also learn how to manipulate the filters on your Power BI visuals to get the data you need. Finally, you’ll learn how to build measures that span multiple time periods or provide end of period calculations.
Business Analyst
Business Analyst
The DAX modeling language allows for calculations in Power BI that are otherwise impossible using calculated columns and quick measures. Business Analysts need to be comfortable doing this type of calculation. In this course, you will learn to enhance your Power BI reports with measures that can solve new problems. You will also learn how to manipulate the filters on your Power BI visuals to get the data you need. Finally, you’ll learn how to build measures that span multiple time periods or provide end of period calculations.
Financial Analyst
Financial Analyst
The DAX modeling language allows for calculations in Power BI that are otherwise impossible using calculated columns and quick measures. Financial Analysts need to be comfortable doing this type of calculation. In this course, you will learn to enhance your Power BI reports with measures that can solve new problems. You will also learn how to manipulate the filters on your Power BI visuals to get the data you need. Finally, you’ll learn how to build measures that span multiple time periods or provide end of period calculations.
Data Scientist
Data Scientist
The DAX modeling language allows for calculations in Power BI that are otherwise impossible using calculated columns and quick measures. Data Scientists need to be comfortable doing this type of calculation. In this course, you will learn to enhance your Power BI reports with measures that can solve new problems. You will also learn how to manipulate the filters on your Power BI visuals to get the data you need. Finally, you’ll learn how to build measures that span multiple time periods or provide end of period calculations.
Data Visualization Specialist
Data Visualization Specialist
The DAX modeling language allows for calculations in Power BI that are otherwise impossible using calculated columns and quick measures. Data Visualization Specialists often need to do this type of calculation. In this course, you will learn to enhance your Power BI reports with measures that can solve new problems. You will also learn how to manipulate the filters on your Power BI visuals to get the data you need. Finally, you’ll learn how to build measures that span multiple time periods or provide end of period calculations.
Business Intelligence Analyst
Business Intelligence Analyst
The DAX modeling language allows for calculations in Power BI that are otherwise impossible using calculated columns and quick measures. Business Intelligence Analysts often need to do this type of calculation. In this course, you will learn to enhance your Power BI reports with measures that can solve new problems. You will also learn how to manipulate the filters on your Power BI visuals to get the data you need. Finally, you’ll learn how to build measures that span multiple time periods or provide end of period calculations.
Data Engineer
Data Engineer
The DAX modeling language is often used by Data Engineers. In this course, you will learn to enhance your Power BI reports with measures that can solve new problems. You will also learn how to manipulate the filters on your Power BI visuals to get the data you need. Finally, you’ll learn how to build measures that span multiple time periods or provide end of period calculations.
Statistician
Statistician
The DAX modeling language allows for calculations in Power BI that are otherwise impossible using calculated columns and quick measures. Statisticians need to be comfortable doing this type of calculation. In this course, you will learn to enhance your Power BI reports with measures that can solve new problems. You will also learn how to manipulate the filters on your Power BI visuals to get the data you need. Finally, you’ll learn how to build measures that span multiple time periods or provide end of period calculations.
Financial Manager
Financial Manager
The DAX modeling language allows for calculations in Power BI that are otherwise impossible using calculated columns and quick measures. Financial Managers often need to do this type of calculation. In this course, you will learn to enhance your Power BI reports with measures that can solve new problems. You will also learn how to manipulate the filters on your Power BI visuals to get the data you need. Finally, you’ll learn how to build measures that span multiple time periods or provide end of period calculations.
Management Consultant
Management Consultant
The DAX modeling language allows for calculations in Power BI that are otherwise impossible using calculated columns and quick measures. Management Consultants often need to do this type of calculation. In this course, you will learn to enhance your Power BI reports with measures that can solve new problems. You will also learn how to manipulate the filters on your Power BI visuals to get the data you need. Finally, you’ll learn how to build measures that span multiple time periods or provide end of period calculations.
Market Researcher
Market Researcher
The DAX modeling language allows for calculations in Power BI that are otherwise impossible using calculated columns and quick measures. Market Researchers need to be comfortable doing this type of calculation. In this course, you will learn to enhance your Power BI reports with measures that can solve new problems. You will also learn how to manipulate the filters on your Power BI visuals to get the data you need. Finally, you’ll learn how to build measures that span multiple time periods or provide end of period calculations.
Operations Research Analyst
Operations Research Analyst
The DAX modeling language may be used by Operations Research Analysts. In this course, you will learn to enhance your Power BI reports with measures that can solve new problems. You will also learn how to manipulate the filters on your Power BI visuals to get the data you need. Finally, you’ll learn how to build measures that span multiple time periods or provide end of period calculations.
Software Engineer
Software Engineer
The DAX modeling language may be used by Software Engineers. In this course, you will learn to enhance your Power BI reports with measures that can solve new problems. You will also learn how to manipulate the filters on your Power BI visuals to get the data you need. Finally, you’ll learn how to build measures that span multiple time periods or provide end of period calculations.
For more career information including salaries, visit:
OpenCourser.com/course/qkgzbm/create
Reading list
We've selected seven books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
Create Measures by Using DAX with Power BI.
Comprehensive reference guide to DAX. It covers all aspects of DAX, from basic syntax to advanced techniques. It valuable resource for anyone who wants to learn more about DAX and how to use it to create powerful Power BI reports.
Provides a comprehensive overview of advanced DAX techniques. It covers topics such as time intelligence, calculated tables, and error handling. It valuable resource for anyone who wants to learn how to use DAX to create more sophisticated Power BI reports.
Save
Provides a comprehensive overview of DAX patterns and best practices, covering topics such as data modeling, performance optimization, and error handling. It valuable resource for anyone who wants to improve their DAX skills and create more effective Power BI reports.
Provides a collection of recipes for solving common problems in Power BI. It can be a useful reference for those looking for quick solutions to specific problems.
Provides guidance on how to use Power BI dataflows. It can be useful for those who want to learn more about dataflows and how to use them to improve the performance of their Power BI reports.
Save
Provides guidance on how to embed Power BI reports into other applications. It can be useful for those who want to share their Power BI reports with a wider audience.
Provides a quick overview of Power BI, including DAX. It can be useful as a starting point for those new to Power BI.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/qkgzbm/create
Share
Similar courses
Here are nine courses similar to
Create Measures by Using DAX with Power BI.
Create Model Calculations by Using DAX
OpenCourser.com/course/obj45j/create
Create Model Calculations by Using DAX
Most relevant
Data Modeling in Power BI
OpenCourser.com/course/cw7018/data
Data Modeling in Power BI
Most relevant
Intermediate DAX & Time Intelligence
OpenCourser.com/course/fp0b5v/intermediate
Intermediate DAX & Time Intelligence
Most relevant
Getting Started with DAX Formulas in Power BI, Power Pivot, and SSAS
OpenCourser.com/course/8zjbcy/getting
Getting Started with DAX Formulas in Power BI, Power...
Most relevant
Power BI for Beginners Introduction to DAX Language
OpenCourser.com/course/08yupu/power
Power BI for Beginners Introduction to DAX Language
Most relevant
Using DAX throughout PowerBI to create robust data scenarios
OpenCourser.com/course/8qwimk/using
Using DAX throughout PowerBI to create robust data...
Most relevant
Design and Build Tabular Models - DP-500
OpenCourser.com/course/t3mfb5/design
Design and Build Tabular Models - DP-500
Most relevant
Modeling Data in Power BI
OpenCourser.com/course/dtehdb/modeling
Modeling Data in Power BI
Most relevant
Power BI Fundamentals
OpenCourser.com/course/63sou1/power
Power BI Fundamentals
Most relevant
Time
69 hours
Level
Introductory
Via
Pluralsight
Instructor
Brent Allen
Language
English
Good to know
Introduces calculations in Power BI that are otherwise impossible using other available functions
Taught by industry-recognized instructor Brent Allen
Covers the CALCULATE formula, which enables advanced data manipulation within Power BI visuals
Suitable for learners seeking to enhance their Power BI reports with advanced calculations
Builds foundations for learners new to DAX and strengthens existing knowledge for intermediate learners
May require prior experience with Power BI and data analysis concepts
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2024 OpenCourser