Pro DAX with Power BI: Business Intelligence with PowerPivot and SQL Server Analysis Services Tabular

© Philip Seamark, Thomas Martens 2019

P. Seamark, T. MartensPro DAX with Power BIhttps://doi.org/10.1007/978-1-4842-4897-3_14

14. Scale Your Models

Philip Seamark¹  and Thomas Martens²

(1)

UPPER HUTT, New Zealand

(2)

Hamburg, Hamburg, Germany

 

Introduction

There are two use cases to compose a DAX statement. The first one is to answer a specific question for a given dataset. The second one is to find an answer for a general question; this solution will allow us to answer similar questions much faster in the future.

For this reason, the latter solutions are also called patterns. At first glance, it seems foolish not to use an existing pattern or to develop a new one. But of course, sometimes it’s not that easy because there is no time for the development ...