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 ‘Function’

Retrieve header fields like response status from Web.Contents in Power BI and Power Query

Many Power Query function not only return their values as advertised in their function documentation, but on top of that a metadata record. This record is like tag that holds (…) Read more

  • 2020-09-19
  • Comment 1
  • Filed under: Function, M, Power BI, Power Query

Transform a query into a function in Power Query and Power BI

In my previous blogpost I’ve described a method how to extract a substring that follows a certain pattern from a string. In this post I show how to transform a (…) Read more

  • 2020-07-15
  • Comments 5
  • Filed under: Function, M, Power BI, Power Query

How not to miss the last page when paging with Power BI and Power Query

When you use an API with a paging mechanism (like the example from this blogpost), you’ll might work with a field that contains the address for the next page. You (…) Read more

  • 2020-05-15
  • Comments 11
  • Filed under: Function, M, Power BI, Power Query

Date.Networkdays function for Power Query and Power BI

Today I’m going to share my custom NETWORKDAYS function for Power Query with you that uses the same syntax than its Excel-equivalent. NETWORKDAYS function This function’s first 3 parameters work (…) Read more

  • 2020-02-20
  • Comments 65
  • Filed under: Function, M, Power BI, Power Query

Advanced transformations on multiple columns at once in Power BI and Power Query

You can apply simple transformations to multiple columns at once in Power Query using the UI only. In this article I show how you can apply advanced transformations on multiple (…) Read more

  • 2019-12-18
  • Comments 9
  • Filed under: Excel, Function, M, Power BI, Power Query

Dynamically create types from text with Type.FromText in Power Query and Power BI

In this article I’ll show you how to create types from text in Power Query, enabling you to dynamically change types via functions for example. It’ll come out as a (…) Read more

  • 2019-11-17
  • Comments 20
  • Filed under: Function, M, Power BI, Power Query
← Older entries
Newer 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 PowerBI Power BI Power Pivot Power Query PowerQuery R SSAS Text transformation Tools
 

Loading Comments...