This article describes how to write efficient DAX expressions that compute the compound interest of incremental investments made throughout the holding period.  Read more

This article describes the reasons why an Excel pivot table may be slow when using the Analyze in Excel feature of Power BI.  Read more

This article describes how to implement a syntax equivalent to the T-SQL function NULLIF and the ANSI SQL function COALESCE, in DAX.  Read more

This article describes how you can create a comparison with the previous time period in a visualization, regardless of whether the time periods are consecutive or not.  Read more

This article describes the differences between eager evaluation and strict evaluation in DAX, empowering you to choose the best evaluation type for your data models.  Read more

This article shows a basic technique used to sort months according to a fiscal calendar, by using a couple of calculated columns and the “sort by column” feature of Power BI.  Read more

This article describes how blank values considered in a DAX conditional expression can affect its query plan and how to apply possible optimizations to improve performance in these cases.  Read more

Creating a star schema in Power BI is the best practice to improve performance and more importantly, to ensure accurate results! This article shows why a star schema can fix some of the issues in your report.  Read more

This article provides information to help choose between DAX and Power Query when a table needs to compute additional columns.  Read more

This article describes how to analyze the performance of a DAX measure based on a DISTINCTCOUNT calculation and how to evaluate possible optimizations.  Read more