-
This article describes how to customize the drillthrough experience in Excel PivotTables connected to Power BI datasets or Analysis Services databases. Read more
-
The Detail Rows Expression in a Tabular model provides the user with control over the drillthrough results obtained by showing details of a measure. This article describes typical DAX expressions you can use in this property. Read more
-
This article describes how to use the detail rows expression of a measure to obtain the equivalent of creating table functions in DAX. This allows the reusing of a table expression in multiple CALCULATE filters. Read more
-
The new video course to create enterprise-level solutions with Power BI and Analysis Services is available! Read more
-
This article explains how the CONTAINS function works and what can be used as better alternatives in DAX in common use cases. Read more
-
This article provides you with the technical knowledge to choose between using a Date or an Integer to create the relationship between your fact table and the Date dimension. Read more
-
This article is the state-of-the-art guide of the development tools for Power BI and Analysis Services models, providing guidance to improve productivity and access to new features. Read more
-
UPDATE 2021-06-29: also read Choosing Azure Analysis Services or Power BI Premium for large datasets – SQLBI containing updates about Power BI Premium Gen2. I often get questions about use cases for Azure Analysis Services. So I wanted to do… Read more
-
Almost 18 months ago I compared Azure Analysis Services and Power BI Premium for large datasets. At that time, Azure Analysis Services was a clear choice, but it is almost time to update that post with a longer article. Because… Read more
-
You can implement the calculation of stock inventory over time in several ways in DAX. The xVelocity technology in Power Pivot and Analysis Services Tabular is so fast that you might consider both dynamic calculation and snapshot-based calculation, depending on… Read more