Topic: Power BI
-
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
-
Alberto answers a user comment asking how to hide calculation items when too many of them are selected in a report. Explore how we analyze the problem and find possible solutions. Watch now
-
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
-
DAX Studio 2.16 has two new preview features: Show Debug Commas and Show XMLA Commands. With Show Debug Commas you enable a button to move commas from the end of a line to the beginning of the following line, which… Watch now
