Organize Your DAX Measures in Power BI
Like many others, I wrote my first DAX measures in Excel Power Pivot. It seemed so natural to add measures in the editing area associated with the fact table I never considered any other way. But while measures specify one or more tables in their code definition, there is really no restriction on “where” they […]
How Does Power BI Fit Into My Business Intelligence Plans?
Things change pretty fast in the business intelligence arena. Terms can change pretty fast, too. A little more than a year ago, many people used the phrase “Power BI” to refer to Excel Add-Ins of particular interest in BI, notably Power Pivot and Power Query. Now, the same phrase refers to a distinct and separate […]
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 […]