Subscriber only lesson.
Sign up to this course to view this lesson.
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.
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.
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.