O'Reilly logo

Microsoft Tabular Modeling Cookbook by Paul te Braak

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Retrieving data from a single table

The first recipe in this chapter examines how to display results from a table in the model; keep in mind that the table may contain calculated columns and these are also included in its structure. The base script includes several alterations, so that segments of the table may be retrieved.

The workbook (with the associated model) is available from the online resources at http://www.packtpub.com.

Getting ready

The model used in this chapter is available from the online resources at http://www.packtpub.com. We have installed DAX Studio so that the model within the workbook can be queried. Alternatively, the model can be imported to a tabular server and queried through SSMS (SQL Server Management Studio) although ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required