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

8. Using DAX to Solve Advanced Reporting Requirements

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

Introduction

Until now, DAX has been used to calculate measures or Calculated Columns, aiming to create and extract insights from the data model. Even if this is the most obvious part of using DAX, it’s not the only place where DAX can be used. Power BI is a data-driven reporting tool that enables its users to explore large amounts of data; Power BI is also a tool that allows to share reports and collaborate with colleagues. This makes it necessary to create reports and dashboards ...

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.