New Generation Finance – Accounting – Controlling using Microsoft BI stack

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

Archives

The BIccountant

New Generation Finance,  Accounting & Controlling using Microsoft BI stack

Business inquiries

info@thebiccountant.com

Log In

Categories

  • Accounting (21)
  • Allgemein (17)
  • Bug warning (3)
  • Charting (8)
  • Cube (7)
  • Data Modelling (10)
  • Dataflow (3)
  • Dataflows (5)
  • DAX (21)
  • Excel (86)
  • Finance (6)
  • Flow (6)
  • Function (23)
  • little Tipps&Tricks (41)
  • M (115)
  • nerdy (9)
  • Power Automate (4)
  • Power BI (153)
  • Power Pivot (27)
  • Power Query (155)
  • Python (1)
  • R (9)
  • SQL (1)
  • SSAS (6)
  • Tools (7)

Search by tag

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

Posts Tagged ‘pivot’

Performance tip to speed up slow pivot operations in Power Query and Power BI

Pivot operations in are a very handy feature in  Power Query but they can slow down refresh performance. So with some bittersweet pleasure I can tell that I found a (…) Read more

  • 2020-05-17
  • Comments 6
  • Filed under: little Tipps&Tricks, M, Power BI, Power Query

Perfect Analysis Services (SSAS) reports in Excel using Power Query

Excel-reports on SSAS cubes (multidimensional and tabular) can have some flaws that now can be overcome by using Power Query for sourcing your cubedata: filter your cube by complete Excel-tables without loading them to the model/cube (…) Read more

  • 2015-09-19
  • Comments 0
  • Filed under: Allgemein, Cube, Excel, Power Query

Want to filter a PivotTable based on an external range or list?

In order to pass a list of filter arguments to your pivot table instead of selecting them all manually you can do the following: 1) Pass your filter table and your (…) Read more

  • 2015-08-21
  • Comments 6
  • Filed under: Excel, little Tipps&Tricks, Power Pivot, Power Query

How to pivot multiple measures and columns in Power Query and Power BI

The pivot-function in Power Query lets you pivot your data within the query already. This comes in handy quite often when you want to further work on those results within (…) Read more

  • 2015-08-12
  • Comments 18
  • Filed under: little Tipps&Tricks, Power Query
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
  • © 2025
  • Powered by WordPress
  • Theme: Tatami by Elmastudio
Top

Follow me!

  • Twitter
  • YouTube
  • GitHub
  • LinkedIn
  • RSS Feed
 

Loading Comments...