The Definitive Guide to DAX second edition now available worldwide
The second edition of The Definitive Guide to DAX is now available worldwide! This blog post explains why we felt the need to rewrite the book and describes what happens behind the scenes when producing a book. Read more
Uncertified connectors message in Power BI Desktop
I recently had an issue in Power BI Desktop that started to display the error message “Uncertified Connectors”. What was really strange is that Power BI was not trusting… Power BI itself! I am not sure whether this started after… Read more
Hate and love for the DAX language
A few weeks ago I woke up on a Saturday morning with a question notified on my Quora feed: Why do all the BI consultants hate DAX? I was challenged to answering the question because I personally love DAX but… Read more
Using DAX with DateTime values
I was recently reading an interesting question by a user. Given a date/time value and a number of hours, add the number of hours to the date, but considering some constraints related to working hours: The working hours are 09:00-17:00… Read more
Calculation Groups in DAX – first impressions
Microsoft announced at SqlBits a very important feature for DAX: Calculation Groups. These are my first impression about the new feature and the impact it will have on Analysis Services and Power BI. Read more
Why Smart Filter Pro does not use IAP
This week OKViz released Smart Filter Pro 2.0.5, which is the first commercial version of a custom visual for Power BI produced by OKViz. This is the first of other rich and advanced visuals that will be released in the… Read more
Detect missing parameters in DAX queries
Yesterday I answered to a question related to parameters in DAX that could be useful to other readers who use DAX in Reporting Services (SSRS): how to manage missing parameters of a DAX query? I wrote an article in the… Read more
Naming variables in DAX
There 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
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
Displaying a list of selected months
Today 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