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...] Infos zum Plugin Query time periods with CUBE formulas in Excel
Wir lieben Microsoft Power BI
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...] Infos zum Plugin Query time periods with CUBE formulas in Excel
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...] Infos zum Plugin How to control Named Sets via Slicer using MDX
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 …
THE SELF-SERVICE-BI BLOG
Mail: lars@ssbi-blog.de