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

Excel NORM.INV function in Power Query and Power BI

The Excel NORM.INV function hasn’t made it into the standard library of M functions for Power Query yet. So here I’m sharing a custom function that replicates it. Excel NORM.INV (…) Read more

  • 2021-12-29
  • Comment 1
  • Filed under: Excel, Function, M, Power BI, Power Query

Black Scholes Option Pricing with Power Query in Power BI

The Black Scholes formula returns the value of European put and call options. The version I’m sharing here uses the standard normal cumulative distribution function from my previous blogpost. Algorithm (…) Read more

  • 2021-12-28
  • Comments 0
  • Filed under: Accounting, Finance, Function, M, Power BI, Power Query

Excel NORM.DIST function in Power Query and Power BI

If you’re looking for Excel functions in Power BI, you will recognize that much more of them have been transformed to native DAX functions than to native M functions in (…) Read more

  • 2021-12-26
  • Comments 5
  • Filed under: Excel, Function, M, Power BI, Power Query

Power BI Cleaner Gen2 now covers Analysis Services Models as well

Edit: Currently it is not available to analyze “thin reports” in the service du to missing authentication feature. The generation of the token via the Power BI Rest API sites (…) Read more

  • 2021-08-23
  • Comments 86
  • Filed under: M, Power BI, Power Query, Tools

Power BI Cleaner now fully covers Calculation Groups

Edit 27th June 2021: There is a complete new version of this tool that has all the bugfixes and enhancements here: https://wp.me/p6lgsG-2pi You can now download a new version of (…) Read more

  • 2021-03-06
  • Comments 3
  • Filed under: M, nerdy, Power BI, Power Query, Tools

Extract only letters from a mixed string in Power Query and Power BI

This is a quick method about extracting only letters from a string. It is part of the Week2 “Preppin’ data” challenge. Task for extracting letters from a string Image you (…) Read more

  • 2021-01-14
  • Comments 7
  • Filed under: 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...