• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Pixcels.nl

  • Home
  • Categories
    • Excel apps
    • Pivottable stuff
    • PowerBI stuff
    • RGS en auditfiles
    • Sheet stuff
    • Userform stuff
    • VBA stuff
    • VBE stuff
    • XML stuff
  • About
You are here: Home / Archives for Categories / PowerBI stuff

PowerBI stuff

The Grand Totals range of a pivottable in Excel

2020/10/19 by Frans

In a recent project I needed the range of the Grand Totals in any pivottable in Excel. Unfortunately the PivotTable object has no property for this. Solutions I found on the Internet were for specific cases. So I developed a generic solution that I want to share with you.

[Read more…] about The Grand Totals range of a pivottable in Excel

Filed Under: Pivottable stuff, PowerBI stuff Tagged With: PivotTable, Power BI, VBA

Replace drill-through for Power Pivot and Power BI pivottables in Excel

2020/09/22 by Frans

Excel’s default drill-through for pivottables connected to a datamodel or Power BI dataset is often not very helpful. The add-in PowerDrill for Excel replaces Excel’s drill-through and gives you full control over the drill details.

[Read more…] about Replace drill-through for Power Pivot and Power BI pivottables in Excel

Filed Under: Excel apps, PowerBI stuff Tagged With: drill-through, PivotTable, Power BI

XAF Explorer voor Power BI

2019/12/20 by Frans

XAF Explorer voor Power BI toont de volledige inhoud van een XML Auditfile Financieel (XAF) en voert diverse controles uit. XAF Explorer is beschikbaar als template en ondersteunt de XAF versies vanaf 3.0.

[Read more…] about XAF Explorer voor Power BI

Filed Under: PowerBI stuff, RGS en auditfiles

Globale straling in Power BI

2019/04/24 by Frans

Om te bepalen of je zonnepanelen goed presteren kun je de gemeten opbrengst in een periode vergelijken met de theoretisch maximaal haalbare opbrengst. Deze verhouding zou altijd constant moeten zijn. Voor het bepalen van de maximale opbrengst moeten we de globale straling weten. Hiervoor is nu een openbare Power BI app beschikbaar.

[Read more…] about Globale straling in Power BI

Filed Under: PowerBI stuff

Primary Sidebar

Recent posts

  • The Grand Totals range of a pivottable in Excel
  • Replace drill-through for Power Pivot and Power BI pivottables in Excel
  • AuditfileValidator for Excel: validate and inspect Xml auditfiles
  • SAF-T auditfiles for test and development
  • Een postcodetabel op basis van BAG Extract 2.0

Recent comments

  • Harry Cuntapay on Replace drill-through for Power Pivot and Power BI pivottables in Excel
  • Lucio on Disable Shift key on open
  • Lucio on Disable Shift key on open
  • Julius Peter on The sequence of events in workbooks
  • Ben on The sequence of events in workbooks

Categories

Tags

ActiveControl ActivePrinter ADCS auditfiles BAG Connection Custom tab Database Debug Direct Debit drill-through Events event trapping Focus IBAN ISO 21378 MDI MSXML Multiple Document Interface normalize PAIN.008 PivotTable postcode Power BI RGS Ribbon SAF-T schema SEPA SOM Table Userforms validate VBA XAF xml XPath

Copyright © 2022 · eleven40 Pro on Genesis Framework · WordPress · Log in