© Philip Seamark, Thomas Martens 2019
P. Seamark, T. MartensPro DAX with Power BIhttps://doi.org/10.1007/978-1-4842-4897-3_10

10. Finding What’s Not There

Philip Seamark1  and Thomas Martens2
(1)
UPPER HUTT, New Zealand
(2)
Hamburg, Hamburg, Germany
 

Introduction

One of the most apparent domains where DAX is applied is the calculation of measures on top of existing data, for example, calculating measures that return cumulated values over time. An area that’s maybe not the first thought if one considers using DAX is to discover missing things. “Missing things” – admittedly – sounds vague; for this reason, it has to be explained in more detail. One of these missing things, for example, is a customer who stops buying.

This chapter is about finding these missing ...

Get Pro DAX with Power BI: Business Intelligence with PowerPivot and SQL Server Analysis Services Tabular now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.