Which SQL Server 2016 Analysis Services Should I Choose?
Choices are always good; more selection means a greater chance of finding exactly what you want. In the world of analytical databases, however, it’s not always clear which choice best suits the needs of an organization. Such is the case with the SQL Server 2016 Analysis Services. The tabular mode of analysis services was introduced […]
Editing DAX Queries with DAX Studio
Among the new features sported by Excel 2016 is the highlighting of DAX keywords in the Power Pivot formula bar. (Just as an aside, this example definition makes use of the new DAX variables.) Any help writing DAX is greatly appreciated, but while the colorization is a nice feature, it would be nicer still to […]
Excel 2016: DAX Variables
DAX Variables Well, DAX variables weren’t actually introduced with Excel 2016; they weren’t even introduced in 2016. Come to think of it, DAX variables aren’t even variables. Nevertheless, DAX variables are one of the most interesting and exciting recent additions to DAX. DAX variables were introduced to the Power Pivot engine in 2015, so […]