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’

Clean up or harmonize mis- or differently spelled category data with Power Query

A typical problem with data that has been created by manual entries is that category values are often misspelled or missed. So in this article I’m showing a very powerful (…) Read more

  • 2021-01-12
  • Comments 3
  • Filed under: M, Power Pivot, Power Query

Calculating doubling times with DAX in Power BI

In this article I show methods to calculate the doubling time with DAX in Power BI. Doubling time is an indicator used for exponential growth scenarios. It indicates how much (…) Read more

  • 2020-03-22
  • Comments 11
  • Filed under: Charting, DAX, Power BI, Power Pivot

Debug DAX variables in Power BI and Power Pivot

When you’re dealing with a beast like DAX you can use any help there is, right? So here I show you how you can debug DAX variables who contain tables (…) Read more

  • 2019-07-04
  • Comment 1
  • Filed under: DAX, M, Power BI, Power Pivot, Power Query, Tools

DAX CALCULATE Debugger

CALCULATE is the most powerful function in DAX, as it allows you to change the filter context under which its expression is evaluated to your hearts content. But with big (…) Read more

  • 2019-05-19
  • Comments 4
  • Filed under: DAX, Excel, M, Power BI, Power Pivot, Power Query, Tools

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 25
  • 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 22
  • Filed under: DAX, M, Power BI, Power Pivot, Power Query
← Older entries
  • © 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 (19)
  • Allgemein (17)
  • Bug warning (2)
  • Charting (8)
  • Cube (7)
  • Data Modelling (11)
  • Dataflow (2)
  • Dataflows (4)
  • DAX (21)
  • Excel (84)
  • Finance (1)
  • Flow (4)
  • Function (19)
  • little Tipps&Tricks (40)
  • M (113)
  • nerdy (9)
  • Power BI (146)
  • 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 PowerBI Power BI Power Pivot Power Query PowerQuery R SSAS Text transformation Tools