© 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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.