The BIccountant

New Generation Finance – Accounting – Controlling using Microsoft BI stack

  • Home
  • Learning resources
  • Speed/Performance aspects
  • About The BIccountant
  • Imprint
  • Datenschutz/Privacy

Archives

  • Menu
  • Sidebar

Posts Tagged ‘Accounting’

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

  • 2017-07-11
  • Comments 4
  • Filed under: Accounting, M, Power BI, Power Query

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

  • 2017-04-24
  • Comments 16
  • Filed under: Accounting, Data Modelling, DAX, M, Power BI, Power Pivot, Power Query

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

  • 2017-03-07
  • Comments 2
  • Filed under: Accounting, Cube, Data Modelling, DAX, Power BI, Power Pivot, SSAS

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

  • 2017-01-23
  • Comments 12
  • Filed under: Data Modelling, DAX, Excel, M, Power BI, Power Pivot, Power Query

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

  • 2017-01-16
  • Comments 22
  • Filed under: Data Modelling, DAX, Excel, M, Power BI, Power Pivot, Power Query

Easy Profit and Loss and other (account) scheme reports in Power BI and Power Pivot using DAX

This is about an easy way to create typical finance reports like Profit and Loss using DAX that (unlike all other solutions I’ve come across so far) can be handled with (…) Read more

  • 2016-07-21
  • Comments 72
  • Filed under: Excel, M, Power BI, Power Pivot, Power Query
Newer entries →
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Privacy Policy / Datenschutzerklärung
  • © 2021 The BIccountant
  • Powered by WordPress
  • Theme: Tatami by Elmastudio
Top

The BIccountant

New Generation Finance,  Accounting & Controlling using Microsoft BI stack

Business inquiries

info@thebiccountant.com

Follow me!

  • Twitter
  • YouTube
  • GitHub
  • LinkedIn
  • RSS Feed

Log In

Search by tag

Accounting Charting Cube DAX Excel Filter Function JSON M Performance pivot PowerBI Power BI Power Pivot Power Query PowerQuery R SSAS Text transformation Tools

Follow me on Twitter

My Tweets