The good folks from SumProduct have published a challenge for Excel that I find worth doing in Power Query instead: The Challenge Stretching or compressing a forecast so that the proportion of (…) Read more
Posts Tagged ‘Accounting’
Right Aligning Text in Power BI: Format Improvements for Easy Profit&Loss Reports
Edit 14-Dec-2017: Now that we can right-align text measures in PowerBI, a SWITCH-measure like here: http://www.thebiccountant.com/2017/04/24/kpis-in-easy-profit-and-loss-for-powerbi/#comment-719 is the best alternative in my eyes. No need to read on 🙂 As (…) Read more
Non-linear Break-Even Analysis in PowerBI
A break-even analysis tells you at which value of the parameter in question your profit-calculation will turn positive (link). Here we need to sell at least 173 at a given (…) Read more
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
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