Topic: DAX
-
SQL 2012 gives you two different xVelocity engines, with different capabilities and different scenarios of implementation, the paper will help you choose the right one or, at least, raise your curiosity about performing more tests on your specific scenario. Read more
-
This article describes the pros and cons of using SQL Server Analysis Services Tabular as the analytical engine in a service or application, based on the experience of companies who have adopted it. Read more
-
We are approaching the end of 2017, 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 2018. New DAX… Read more
-
This article describes how DAX resolves column and measure names in DAX, providing best practices to avoid conflicting names. Read more
-
During a conversation at PASS Summit, one of the developers of Power BI shown me a way to use TREATAS in place of IN in DAX. I am not sure it increases readability of the code, but let’s examine pros… Read more
-
I recently stumbled across a strange behavior of HASONEVALUE, which also impacts the SELECTEDVALUE function. When the only selected item in a column is a numeric value 0 and the column also contains a blank value, there is a bug… Read more
-
A few months ago, I and Alberto realized that the reason why variables are not used in DAX as they should is that… there are not many examples out there! For this reason, we made a commitment to use them more… Read more
-
In the second half of 2017 I will deliver sessions and preconference days in two big events. I’d like to recap my sessions here, let me know if you have any questions about them. Microsoft Ignite 2017 – September 25-29,… Read more
-
You can connect an Excel workbook to a Power BI model in two ways: Using the Analyze in Excel action in powerbi.com Using the Connect to Data action in the ribbon of Power BI publisher for Excel In both cases,… Read more
-
I recently wrote a few articles about a new function in DAX and the use of variables. For those of you using Power BI or Azure Analysis Services, you always have access to the latest version of the language. Well, in reality I see that new features appears Read more