-
This article contains a short checklist of what you have to do in order to optimize the memory used by a data model in PowerPivot or in Analysis Services Tabular, including links to tools and resources that can help you… Read more
-
In PowerPivot for Excel 2010 it is possible to import an Excel table in a PowerPivot data model by using the Linked Table feature. Excel 2013 expands this capability by Read more
-
This article explains why in many cases, MAX should be used instead of LASTDATE to search for the last date in a time period using DAX. Read more
-
The DAX language provides several Time Intelligence functions that simplify writing calculations such as year-to-date (YTD), year-over-year (YOY) and so on. However, if you have a special calendar structure such as a 4-4-5 weeks’ calendar, you need to write your… Read more
-
This article describes how to use calculation groups to dynamically replace only a partial expression in a complex DAX calculation. Read more
-
Hardware and virtualization settings have a big impact on Analysis Services Tabular performance. This article describes best practices for the most important settings to check. Read more
-
This article explains the behavior of LASTNONBLANK, LASTNONBLANKVALUE, and similar DAX functions, also providing patterns for performance optimization. Read more
-
This article describes how to create Key Performance Indicators (KPI) in a Power BI Desktop data model by using Tabular Editor. Read more
-
The LOOKUPVALUE function retrieves values from a table in a simple way, but it involves a hidden level of complexity. This article provides full coverage of the LOOKUPVALUE internals, alongside several performance considerations. Read more
-
This article shows the reader how to use LOOKUPVALUE, which is a handy function for any developer to have in their toolbelt. Read more