In this chapter, we're going to look at the concept of DAX patterns. As with other software design patterns, a DAX pattern consists of a template that forms the basis of a reusable solution to a commonly encountered problem.
We'll start with an introduction to the Quick Measures feature in Power BI Desktop. As the name suggests, this is a quick and easy way to create a DAX measure, without needing to know any DAX code. Behind the scenes, it uses predefined DAX patterns that are completed using the responses you provide through the Quick Measures dialog.
Having explored how the Quick Measures feature works, we'll look at some examples of the measures that are available by using them with hands-on examples.
The chapter is broken into the following sections:
- Introducing Power BI Quick Measures
- Calculating cumulative totals
- Binning data using...