Topic: Power BI
-
Ho to use DAX expressions to control and customize the range of charts in Power BI. Watch now
-
You can rely on DAX expressions to control the behavior of some aspects of Power BI visuals. This article shows a few examples of managing the range of charts. Read more
-
This article describes how to analyze the performance of a DAX measure based on a DISTINCTCOUNT calculation and how to evaluate possible optimizations. Read more
-
This article describes how to read the active security roles in a Tabular model for Power BI or Analysis Services. This way, you can use measures and calculation groups to customize a report based dynamically on security roles active for… Read more
-
This article describes a reference Date table in DAX using a Power BI template. The same technique can be used in Analysis Services models. Download the latest version of the template in the Dax Date Template page. Read more
-
Learn how to use the new DAX window functions (INDEX, OFFSET, and WINDOW) to manipulate tables by sorting and partitioning data. Read more
-
Learn how to use calculation groups and how they work internally. The whitepaper is a companion to the related SQLBI+ video course. Read more
-
How to apply dynamic security roles in a hierarchical organization to minimize the maintenance effort on the security configuration and obtain the best performance at query time. Watch now
-
Choose between many-to-many relationships and DAX code to filter the most relevant items using another slicer. Indeed, calculation groups cannot use relationships! Watch now
-
This article describes how to apply dynamic security roles in a hierarchical organization to minimize the maintenance effort on the security configuration and obtain the best performance at query time. Read more