-
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
-
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,… Read more
-
The last update of Power BI Designer allows you to create measures (not calculated columns yet). Download the new version of Power BI Designer and you will see the New Measure button. The editor is much better than anything you… 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
-
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
-
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
-
In the latest weeks I received several requests to support a different color for variable names in DAX Formatter, just as the formula editor available in Power BI. I finally implemented a solution that I consider a workaround, because of… Read more
-
A few hours ago, DAX Studio 2.5.0 has been released, with a number of small new features (I will write about DirectQuery and new column in Server Timings in a future blog post and article). In the many bug fixes,… Read more
-
After months of public preview, Microsoft today is releasing the Power BI service to general availability. The preview was really a beta that evolved in these months, and I personally liked the approach that MS developers have now. I did… Read more
-
In the last few days I tested several ways to generate surrogate keys when loading a dimension into a data mart. The classical approach with SQL Server is to rely on a INT IDENTITY column. It works fine, but you… Read more