Latest posts

Strange behavior of HASONEVALUE and SELECTEDVALUE

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 in the current implementation that does not identify such a


Latest news from PASS Summit 2017

PASS Summit is the largest conference about the Microsoft Data Platform technology. Started as a Professional Association for SQL Server community, now the PASS brand includes the many technologies included in the Microsoft Data Platform. It is a large and active community, and the PASS Summit is the biggest annual


Offline model editor experience for Power BI

Professional BI developers using Analysis Services and advanced users working with Power BI share a common pain. Their productivity editing a large data model is much lower than what you might expect in 2017. There are many reasons for that. The most important ones are the automatic update of the


Why data modeling is important in #powerbi

I have a long experience in working on reporting systems based on semantic models. Now we call them “self-service BI”, but the principles are the same we had in DSS (decision support system), OLAP (on-line analytical processing), and many other names that we’ve seen over the years. The basic idea


Missing automatic update of Data Gateway for Power BI

Recently Microsoft unified the Data Gateway so that you have a single gateway for Power BI, Azure Analysis Services, Power App, Flow and maybe much else. However, it seems that automatic updates are not even planned at the moment as a feature for the Data Gateway. I understand that there


The easiest way to start using variables in #dax

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 often in our example. We didn’t do that in 2015


Sessions and preconference at Microsoft Ignite and PASS Summit

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, 2017 – Orlando, FL Preconference full day – September 24


New function and the importance of variables in #dax

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

Page 1 of 7012345...102030...Last »