If your Excel file contains an Excel data model, you have the possibility to query this data model using so-called CUBE formulas within the Excel cells. This …
[Weiterlesen...] ÜberQuery time periods with CUBE formulas in Excel
MDX
How to control Named Sets via Slicer using MDX
In my last post How to build asymmetric pivots on Power Pivot data models I showed you how to build asymmetric reports with Power Pivot, using Named Sets. The …
[Weiterlesen...] ÜberHow to control Named Sets via Slicer using MDX
How to build asymmetric pivots on Power Pivot data models using Named Sets
There are many financial reports out there, which have an asymmetric design, to give you all the numbers you need, for a certain place in time. Take a look at …
[Weiterlesen...] ÜberHow to build asymmetric pivots on Power Pivot data models using Named Sets