Create Measures by Using DAX with Power BI 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 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.

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

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

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

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.

See salaries and explore the career path for Power BI Developer

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.

See salaries and explore the career path for Data 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.

See salaries and explore the career path for Business 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.

See salaries and explore the career path for Financial Analyst

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.

See salaries and explore the career path for Data Scientist

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.

See salaries and explore the career path for Data Visualization Specialist

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.

See salaries and explore the career path for Business Intelligence Analyst

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.

See salaries and explore the career path for Data Engineer

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.

See salaries and explore the career path for Statistician

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.

See salaries and explore the career path for Financial Manager

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.

See salaries and explore the career path for Management Consultant

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.

See salaries and explore the career path for Market Researcher

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.

See salaries and explore the career path for Operations Research Analyst

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.

See salaries and explore the career path for Software Engineer

Create Measures by Using DAX with Power BI

What's inside

Syllabus

Good to know

Save this course

Activities

Career center

Reading list

Share

Similar courses