Topic: Power BI
-
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
-
How to force a measure to return zero instead of blank, in order to highlight combinations of attributes with no data. Watch now
-
Explore how to create custom groups based on a slicer selection in Power BI. For example, create two versions of a measure: one returns the value of the selected items, and another one returns the value of the other items,… Watch now
-
Learn what happens when you open a PBIX file with Power BI Desktop and why you might wait many seconds with large files. Do you need more RAM or a faster CPU? As usual, it depends, but if you can… Watch now
