Beginning DAX with Power BI: The SQL Pro’s Guide to Better Business Intelligence

© Philip Seamark 2018

Philip SeamarkBeginning DAX with Power BIhttps://doi.org/10.1007/978-1-4842-3477-8_9

9. Practical DAX

Philip Seamark¹ 

(1)

UPPER HUTT, New Zealand

 

This chapter focuses on building a model using DAX and without using external data sources. In this chapter, you build your own dataset. All data is generated using step-by-step examples that showcase various tips and techniques you may find useful.

The final model has a structure resembling what you might use for a small organization with tables for sales, dates, and products. Because the number of rows for each table is automatically generated, you can use the final model for optimizing DAX calculations over a large dataset. By changing a few numbers here and there, you can generate ...