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 in Category ‘Power Pivot’

Why Power BI isn’t suitable for Financial Statements (… currently … hopefully …)

!! This is a clickbait post to get your vote for some missing features in Power BI !! Although this might not be what the inventors of Power BI had (…) Read more

  • 2018-11-16
  • Comments 32
  • Filed under: Accounting, DAX, Power BI, Power Pivot

Memory efficient clustered running total in Power BI

Today I want to share a scenario where a running total calculation in the query editor saved a model that run out of memory when done with DAX: Problem The (…) Read more

  • 2018-09-30
  • Comments 23
  • Filed under: DAX, M, Power BI, Power Pivot, Power Query

DAX evaluation context indicator with syntax highlighting

This is a post about a feature request, that definitely would make my life easier (and I guess others’ too): Evaluation context and its transition is one of the hardest (…) Read more

  • 2017-11-28
  • Comments 0
  • Filed under: DAX, Power BI, Power Pivot

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

  • 2017-10-29
  • Comments 14
  • Filed under: Accounting, Data Modelling, DAX, M, Power BI, Power Pivot, Power Query, SSAS

How to open a complex JSON record in Power BI and Power Query

Today I’ll show you a very useful technique how to deal with a JSON record that contains a wild mixture of different elements like this: If you click on one (…) Read more

  • 2017-08-30
  • Comments 4
  • Filed under: Data Modelling, Excel, little Tipps&Tricks, M, Power BI, Power Pivot, 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
← Older entries
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
  • © 2023 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 (24)
  • Allgemein (17)
  • Bug warning (3)
  • Charting (8)
  • Cube (7)
  • Data Modelling (11)
  • Dataflow (3)
  • Dataflows (5)
  • DAX (23)
  • Excel (89)
  • Finance (6)
  • Flow (6)
  • Function (22)
  • little Tipps&Tricks (41)
  • M (117)
  • nerdy (9)
  • Power Automate (3)
  • Power BI (154)
  • Power Pivot (29)
  • Power Query (157)
  • Python (1)
  • R (9)
  • SSAS (6)
  • Tools (7)

Search by tag

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

Loading Comments...