## About this lesson

Quick measures are ready-rolled formula patterns built through a drag and drop user interface, allowing you to write really complicated formulas for you without having to learn all the nuances of Power BI's DAX formula language.

## Exercise files

Download this lesson’s related exercise files. You can download the source data files for the course from the resources section of your Lessons page.

Quick Measures.pbix450.7 KB Quick Measures - Completed.pbix

451.5 KB

## Quick reference

### Quick Measures

Using quick measures for time intelligence.

### When to use

Quick measures are handy patterns that you can use to quickly create complex DAX patterns that you may not be able to write on your own.

### Instructions

Before you create a quick measure

- Create a basic measure to aggregate your data (SUM, COUNT, etc…)

Creating quick measures

- Right click your measure in the Fields window -> Quick Measures
- Choose your measure pattern
- Configure as desired

Example: Year to date Sales based on the Sales[Amount] column

- Create a basic measure: Sales $= SUM(Sales[Amount])
- Right click the [Sales $] measure -> Quick Measures
- Select Time Intelligence -> Year-to-date total
- Set the Base Value to [Sales $]
- Set the Date to Calendar[Date]
- Use the measure on a visual

### Hints & tips

- Always base your quick measures off explicit measures
- Once created, Quick Measures can be edited like any other measure
- Rename by right clicking the measure in the Field list -> Rename
- Change formats by selecting the measure in the Field list -> Modeling -> change the formatting

- If you don’t see Quick Measures, go to File -> Options -> Preview Features to turn it on

Lesson notes are only available for subscribers.