MSBI 2018 Feature List This post identifies 11 MSBI features and enhancements that could be delivered later this year. Similar to the Power BI Feature Report,
Tag: Excel
Dynamic Dates via DAX
Dynamic DAX Date Queries The following zip file contains two DAX queries that dynamically calculate 23 date dimension values. Both queries produce the same result set but
SSAS Tabular 2016 Metadata Reporting
The following Excel workbook available for download contains 10 report pages to describe primary components of SSAS Tabular 2016 databases at the 1200 compatibility level: SSAS Tabular 2016
Is a Power Pivot Pro a BI Pro? No.
Over the past several weeks readers have posted questions concerning the career paths of Excel and Power BI professionals. In general, these questions take the form
Power BI Desktop and Excel 2016
Complete Solution In the MS Ignite session Innovate with MSBI in the Enterprise, Kamal Hathi, GM for Power BI, introduced the following slide as ‘BI on your Terms’ and
DAX Queries to Support New Chart Types
Hi All, In my post two weeks ago on the new modern chart types in Excel 2016 (e.g. Treemap, Sunburst, Waterfall, etc) I left out the following two important points:
Insight Quest 