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 Tagged ‘Excel’

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 2
  • 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

Create Power BI Metrics/Goals Scorecards from Excel files using Power Automate

I like Power BI scorecards a lot, as they give a really nice interface and look to your and your teams goals. However, entering all goals manually can become a (…) Read more

  • 2022-10-10
  • Comment 1
  • Filed under: Excel, Power Automate, Power BI

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

Excel YEARFRAC function for Power Query

While there is a native YEARFRAC-function in DAX that you can use to calculate year fractions, sometimes you might just need it in Power Query. The function I’m presenting here (…) Read more

  • 2022-03-12
  • Comment 1
  • 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
  • © 2023 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 (24)
  • Allgemein (17)
  • Bug warning (3)
  • Charting (8)
  • Cube (7)
  • Data Modelling (11)
  • Dataflow (3)
  • Dataflows (5)
  • DAX (23)
  • Excel (89)
  • Finance (6)
  • Flow (6)
  • Function (22)
  • little Tipps&Tricks (41)
  • M (117)
  • nerdy (9)
  • Power Automate (3)
  • Power BI (154)
  • Power Pivot (29)
  • Power Query (157)
  • Python (1)
  • R (9)
  • SSAS (6)
  • Tools (7)

Search by tag

Accounting Charting Cube DAX Excel Finance Flow Function JSON M Performance PowerBI Power BI Power Pivot Power Query PowerQuery R SSAS Text transformation Tools
 

Loading Comments...