article –
DAX error messages in Power BI
This article describes the real meaning of and the required action for a few common error messages that can appear when users define DAX expressions in Power BI. Read more
blog post –
Naming variables in DAX
Marco RussoThere is an existing limitation in the current version of DAX, regarding what names you provide to variables in a DAX expression: a variable name cannot be the name of a table in the data model. This is not a… Read more
Video –
Jul 24, 2018
Power BI DAX optimization examples
More videos
Mar 25-27 - Chicago
May 8-10 - Amsterdam
Jul 23-25 - Melbourne
Mar 13-15 - London
Video Training
Introducing DAX Video CourseFree
blog post –
What has happened in the DAX world in 2018
We are approaching the end of 2018, so it is a good time to review what happened in the DAX world this year, what we’ve been up to at SQLBI and what is going to happen in 2019. New DAX… Read more
blog post –
Displaying a list of selected months
Alberto FerrariToday I woke up with an interesting question, about how to show a selection of months in a nice way, detecting contiguous selection. You can easily understand the desired solution from the following figure: I enjoyed writing a quick solution,… Read more
DAX Patterns
ABC Classification – Dynamic
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
Book –
Microsoft Press
Analyzing Data with Power BI and Power Pivot for Excel
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