-
Visual calculations are a new feature in DAX that aims to simplify the use of DAX for users by introducing calculations at the visual level rather than at the model level. Read more
-
This advanced paper explains how SUMMARIZECOLUMNS works internally, providing insight into how to control its behavior in queries and measures following a list of best practices. Read more
-
How to implement security in Tabular semantic models considering different requirements, data model design, DAX implementation, and performance. Read more
-
Learn how to write DAX queries and how to manipulate tables in DAX measures and calculated columns. Read more
-
Learn the internals of Power BI semantic models created by using VertiPaq, DirectQuery over SQL, and DirectQuery for Power BI datasets and Analysis Services. Read more
-
Learn how to use the new DAX window functions (INDEX, OFFSET, and WINDOW) to manipulate tables by sorting and partitioning data. Read more
-
Learn how to use calculation groups and how they work internally. The whitepaper is a companion to the related SQLBI+ video course. Read more
-
The SQLBI Methodology defines architecture and implementation of advanced BI solutions using Microsoft SQL Server, SQL Server Analysis Services and – more generally – the Microsoft suite for Business Intelligence. Read more
-
This white paper explores many different uses of many-to-many relationships in both SQL Server Analysis Services Multidimensional and Tabular models. Read more
-
This article describes the pros and cons of using SQL Server Analysis Services Tabular as the analytical engine in a service or application, based on the experience of companies who have adopted it. Read more