Topic: Power BI
-
Tabular models (including Power BI) require marking the Date table as a date table to get appropriate results with time intelligence calculations. This article explains why this setting is required. Read more
-
ALLEXCEPT is a handy DAX function to retrieve all the columns of a table except for some. When used as a CALCULATE modifier, its behavior is less intuitive and might result in inaccurate measures. In this article, we elaborate on… Read more
-
The new video course to create enterprise-level solutions with Power BI and Analysis Services is available! Read more
-
Modify the formula of an article answering a reader question: How to compute the last 6 months of transactions using the last transaction date of each customer, using a range of dates that is different for every customer. In the… Watch now
-
Discover the pros and cons of disabling attribute hierarchies in Power BI and Analysis Services by modifying the “Available in MDX” property. We will analyze the difference in memory and performance that you can obtain by modifying a Power BI… Watch now
-
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
-
Compare different DAX formulas to add ten working days to a date in a Power BI calculated column. Alberto explores the options using DAX Studio and query calculated columns to compare the efficiency of different approaches. Watch now
-
Large models in Power BI Premium have now a larger segment size like Analysis Services. Is this important? Does it improve compression or performance? When? This unplugged video shows the early tests and benchmarks, in preparation for a future and… Watch now
-
This article shows how to use calculation groups to define a default set of values for columns in your model. Different users can have different default values, and yet retain the full capability to select different values. Read more
-
Convert a “Top N and others” measure pattern into a calculation group that can be applied to any DAX measure in a Power BI model. Watch now
