While the relationships view of the datamodel provides a very good overview which tables are connected to each other, one cannot see at a glance on which field they are (…) Read more
Posts in Category ‘Power Pivot’
KPIs in Easy Profit and Loss for PowerBI
Welcome to the last part of my Easy Profit & Loss series where I will cover KPIs in rows & columns: 1) KPIs in columns Show all your figures as (…) Read more
Guide for switching Signs in Power BI and Power Pivot (bypassing Unary Operators in DAX)
In finance & accounting, you very rarely report the figures with the signs of their source systems, but switch (certain) signs according to different needs. Instead of using unary operators (…) Read more
Dynamically flatten Parent-Child Hierarchies in DAX and PowerBI
If you use DAX to flatten Parent-Child hierarchies you will end up with a table that has a static number of columns (like described here). If you need a dynamic (…) Read more
Comfort Functions for Easy Profit & Loss statements in Power BI and Excel – Part2
Here comes some long awaited comfort functions for part 2 of my easy P&L series. In the first section I’ve presented the general principle on how to work with a (…) Read more
Easy Profit & Loss (and other account) statements in PowerBI and Excel – Part2
Welcome to part 2 of my series of easy Profit & Loss and other account statements in Power BI and Excel. In the first part I introduced the general principle (…) Read more