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 ‘BOM’

Bill of Materials Implosion or “Where used Analysis” in Excel and Power BI

This is the last part of my little series about bill-of-materials (BOM) calculations made easy with M in Power BI and Power Query: The implosion that shows where each part (…) Read more

  • 2017-06-18
  • Comments 0
  • Filed under: Accounting, Excel, M, Power BI, Power Query

Bill of Material (BOM) Explosion Part2: Costing in Excel and PowerBI

Following up on the BOM-explosion: A comment reminded me that I had missed to present the costing techniques to calculate the total costs of each (sub)-product. Reversing the aggregation direction What (…) Read more

  • 2017-06-13
  • Comments 5
  • Filed under: Accounting, Data Modelling, DAX, Excel, M, Power BI, Power Pivot, Power Query
  • © 2022 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

Categories

  • Accounting (20)
  • Allgemein (17)
  • Bug warning (2)
  • Charting (8)
  • Cube (7)
  • Data Modelling (11)
  • Dataflow (2)
  • Dataflows (4)
  • DAX (22)
  • Excel (84)
  • Finance (2)
  • Flow (4)
  • Function (19)
  • little Tipps&Tricks (40)
  • M (113)
  • nerdy (9)
  • Power BI (147)
  • Power Pivot (27)
  • Power Query (152)
  • Python (1)
  • R (9)
  • SSAS (6)
  • Tools (7)

Search by tag

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

Loading Comments...