## 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.