This article describes how DAX automatically converts data types in arithmetic operations. These small details can cause and explain differences in results when using the same operations in other languages. Read more
This article shows how to improve line charts with a date-based X-Axis in Power BI using DAX, and how to make correct choices in the data modeling and visualization properties. Read more
This article describes how variables should be used in DAX expressions involving IF and SWITCH statements in order to improve performance. Read more
This article describes how to create a measure displaying the name or value of an element that has a specific ranking, with different option for managing ties. Read more
The dynamic version of the ABC Classification pattern is an extension of the Dynamic Segmentation pattern It groups items such as Products or Customers into segments based on their cumulated sales and how much they contributed to the total sales… www.sqlbi.com
How can you use Excel and Power BI to gain real insights into your information? As you examine your data, how do you write a formula that provides the numbers you need? The answers to both of these questions lie with the data model. Read more
Mar 25-27 - Chicago
May 8-10 - Amsterdam
Mar 13-15 - London