We write articles and white papers on Microsoft Business Intelligence technologies on a regular basis. The list below showcases all our content sorted chronologically - you can filter through the content by post type, topic, and author.
     Page 13 of 877 posts
blog post –

Leverage INTERSECT to apply relationships in DAX

If you are used to virtual relationships in DAX (see Handling Different Granularities in DAX ), you probably use the following pattern relatively often: [Filtered Measure ] := CALCULATE (     <target_measure>,     FILTER  Read more

blog post –

Happy Birthday Power BI #powerbi

Power BI has been on the market one year. My biggest concern, when the product was still in private beta, was the promise of monthly releases made by Microsoft. Today, I can say that the promise was real. I see a long road ahead, in terms of features  Read more

article –

Physical and Virtual Relationships in DAX

DAX calculations can leverage relationships present in the data model, but you can obtain the same result without physical relationships, applying equivalent filters using specific DAX patterns. This article show a more efficient technique to apply virtual relationships in DAX…  Read more

article –

Optimizing DAX expressions involving multiple measures

Writing measures referencing other measures is in general a good idea that simplifies the DAX code, but you might face specific bottlenecks. This article describes which performance issues might arise when different measures aggregate the same column using different filter…  Read more

article –

Many-to-many relationships in Power BI and Excel 2016

The new DAX available in Excel 2016 and the data model in Power BI and Analysis Services 2016 offer tools to manage many-to-many relationships in a more efficient way than previous version, as described in this article.  Read more

blog post –

New formula to compute new customers in #dax

Two years ago I and Alberto Ferrari spent time discussing techniques to calculate new and returning customers, and we wrote the result of our study in the New and Returning Customer article in DAX Patterns web site and book . During one of the Mastering  Read more