Financial Modelling in PowerBI – Downloads

For my session in SQL bits on Financial Modelling in PowerBI there are couple of useful downloads if you want to follow or dissect at home.1) AdventureWorksDW2017This data warehouse has an albeit basic data warehouse version of an accounting table and Account Dimension, so good to use as a demo and starting point.https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorks2017.bak 2) PowerBI … Continue reading Financial Modelling in PowerBI – Downloads

Dealing with Blanks Ragged Hierarchies in PowerBI (ISINSCOPE)

While the Matrix Control does has some new features for automatically handling ragged hierarchies as described by Reza Rad and others  (https://radacad.com/removing-blanks-from-organizational-ragged-hierarchy-in-power-bi-matrix-visual), it falls short of what we want to achieve on most of my projects and still doesn’t come up to where MOLAP was with its automatic support via HideMemberIf This is the approach … Continue reading Dealing with Blanks Ragged Hierarchies in PowerBI (ISINSCOPE)