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 in Category ‘M’

Decode URI in Power Query with custom Uri.UnescapeDataString function

When working with cloud data sources you might encounter links where spaces show up as “%20” instead for example. This is called URI escaping or encoding. In Power Query there (…) Read more

  • 2023-08-01
  • Comments 4
  • Filed under: Function, M, Power BI, Power Query

Reference an intermediate step from a different query in Power Query

When you reference another query in Power Query you will automatically get the results of the final step. But what if you want to reference a step that sits within (…) Read more

  • 2023-02-07
  • Comments 37
  • Filed under: little Tipps&Tricks, M, Power BI, Power Query

Payment function (PMT) for Power Query

While Excel and DAX have native functions to calculate the payment amount for a loan, Power Query lacks it still. As this is a very useful function, it’s time to (…) Read more

  • 2023-01-03
  • Comments 3
  • Filed under: Accounting, Excel, Finance, Function, M, Power BI, Power Query

Future Value function (FV) for Power Query

While Excel and DAX have native functions to calculate the future value of a payment series, Power Query lacks it still. So it’s time to create our own function for (…) Read more

  • 2023-01-02
  • Comment 1
  • Filed under: Accounting, Excel, Finance, Function, M, Power Pivot, Power Query

Present Value (PV) function for Power Query

Finally 2023 is here, the year we expect Power Query function libraries to ship. This will make it so much easier to re-use ready made function than M-extensions. So let’s (…) Read more

  • 2023-01-01
  • Comment 1
  • Filed under: Accounting, Excel, Finance, Function, M, Power BI, Power Query

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 4
  • Filed under: Excel, Function, M, Power BI, Power Query
← Older entries
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...