Percentages and Integers in the same measure
How to create Percentages and Integers in the same measure within Power BI
top of page
Articles
Deviating from Star Schema Principles
A finance user case The Star Schema methodology is the application of dimensional modelling techniques to a relational database. This...
Know your facts Part 4: Power BI, Financial Statements & Kimball
Mixed Grain Fact Tables Granularity is determined by the number of foreign keys in the fact table. For instance, the grain of your...
Know your facts Part 3: Power BI, Financial Statements & Kimball
Statement of Cash flows With the Statement of Comprehensive Income (SOCI) and Statement of Financial Position (SOFP) there are no...
Know your facts Part 2: Power BI, Financial Statements & Kimball
The first part of this series examined the TRANSACTIONAL fact table as the optimal solution for Statement of Comprehensive Income (SOCI)....
Know your facts Part 1: Power BI, Financial Statements & Kimball
How the Kimball methodology aligns with Power BI for the Statement of Comprehensive Income
Using your Organisational Hierarchy as the basis for report security
How using the organisational hierarchy to set security rules saves time & creates a more maintainable, scalable and transparent solution
The 3 things you need to get started with Financial Statements in Power BI
Getting started with Power BI and the Financial Statements
bottom of page