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

All Posts by Imke Feldmann

Forecasting with seasonality in Power BI

Today I’m starting a small series about forecasting in Power BI. In this blogpost I’ll start with a basic example about forecasting with seasonality that I will build upon in (…) Read more

  • 2022-05-29
  • Comments 5
  • Filed under: Accounting, DAX, Finance, Power BI

Create (empty) table string from schema in Power Query

When your query returns an error, sometimes it could make sense to return an empty table instead of a simple error message. And ideally, this table has the same columns (…) Read more

  • 2022-05-12
  • Comment 1
  • Filed under: Allgemein

Fill values to the right in Power Query and Power BI

While Power Query provides a convenient method to fill values from selected columns up- and downwards, there is no native option to do this to the right or left. So (…) Read more

  • 2022-03-27
  • Comments 2
  • Filed under: Excel, Function, M, Power BI, Power Query

Why are Power Platform Dataflows adding steps automatically at the end?

Have you ever come across the case where you open your dataflow and find 2 additional steps at the end of your query? Why are Power Platform Dataflows adding steps (…) Read more

  • 2022-03-25
  • Comment 1
  • Filed under: Allgemein

TRIMMEAN function for Power Query and Power BI

TRIMMEAN is a statistical function in Excel that calculates the “mean taken by excluding a percentage of data points from the top and bottom tails of a data set”. So (…) Read more

  • 2022-03-14
  • Comment 1
  • Filed under: Excel, Function, M, Power BI, Power Query

Excel WEEKNUM function for Power Query

If you are looking for the Excel equivalent of the WEEKNUM function for Power Query this article is for you. As this is also a function that has many regional (…) Read more

  • 2022-03-14
  • Comments 2
  • Filed under: Excel, Function, M, Power BI, 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 (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