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


Smart Filter Pro update
A new version of Smart Filter Pro (v2.1.1) is now available.
It includes minor bug fixes and new features:
  • Placeholder text color property
  • Custom sorting for multiple fields
Smart Filter Pro Release notes
Download (free trial)


Courses highlights
Reach your 2020 goals by learning DAX at one of our live workshops!

  Houston (Feb 5-7)

  San Francisco (Mar 11-13) Early Bird

  Charlotte (Mar 24-26)

  Munich (Mar 31-Apr 2)


Latest news
• Power BI refresh scheduling using Outlook and Power Automate
Chris Webb shows how to combine Outlook and Power Automate (did you know that's the new name of Microsoft Flow?) in order to design a complete customized Power BI Refresh schedule. Interesting learning experience - we would never have thought of using Outlook this way!
Jan 13,2020 · Chris Webb
• Getting started with the new Power BI Activity Log API
Paul Turley shows how to create a Power BI report importing the Power BI Activity Log using Power Shell. You might expect a Power BI-friendly way to do this, but Paul explains why the JSON format is the easier format to deal with in this case.
Jan 6,2020 · Paul Turley
• Importing Power BI Event Activity Log in Power Query
Miguel Escobar included the Power BI Event Activity Log API in his Power BI REST API Custom Connector. Easier to use than the Power Shell approach, but we always appreciate having options.
Jan 7,2020 · Miguel Escobar
• How to make DAX Distinct Counts 100x Faster with Aggregations
Greg Galloway explains how to optimize distinct count calculations on large Analysis Services data models, where "large" is 18 billion rows. Aggregations are not free, forget clicky-clicky-draggy-droppy here.
Jan 4,2020 · Greg Galloway

DAX Guide