This page has 0 threads | Add post

Blogs

Many people around the world enjoy and benefit from our blogs. If you're one of them - and can afford to - please make a small donation to help keep this and future blogs, exercises, skills assessment tests, tips, tutorials and videos freely available to everyone!

Some other pages relevant to these blogs include:

You can also book hourly online consultancy for your time zone with one of our 7 expert trainers!

Changes in the July 2020 update to Power BI Desktop Part two of a six-part series of blogs
This month's modest update allows you to use Excel financial functions in DAX, show a gradient legend and change your slicer header, among other minor changes. Changes in the July 2020 update to Power BI Desktop Using financial functions from Excel in Power BI (this blog) Gradient legends Customisable slicer headers Relative time filters Q + A updates

Changes in the July 2020 update to Power BI Desktop

Part two of a six-part series of blogs

This month's modest update allows you to use Excel financial functions in DAX, show a gradient legend and change your slicer header, among other minor changes.

Changes in the July 2020 update to Power BI Desktop
Using financial functions from Excel in Power BI (this blog)
Gradient legends
Customisable slicer headers
Relative time filters
Q + A updates

Posted by Andy Brown on 15 November 2023

We've been creating our idiosyncratic monthly blogs on Power BI updates since November 2016, and also deliver online and classroom Power BI courses.

Using financial functions from Excel in Power BI

Excel has a host of functions for calculating interest rates, depreciation, pricing, yields and the value of investments. Now so too does Power BI!

An example of a DAX financial function: calculating the monthly mortgage payment for a range of different borrowing scenarios.

Microsoft have imported "almost all" Excel financial functions into DAX, and kept the same argument signature for each:

The PMT function, as one example - the list of arguments is identical to those in the Excel equivalent.

Here are the functions you can use:

ACCRINT, ACCRINTM, AMORDEGRC, AMORLINC, COUPBAYBS, COUPDAYS, COUPDAYSNC, COUPNCD, COUPNUM, COUPPCD, CUMIPMT, CUMPRINC, DB, DDB, DISC, DOLLARDE, DOLLARFR, DURATION, EFFECT, FV, INTRATE, IPMT, ISPMT, MDURATION, NOMINAL, NPER, ODDFPRICE, ODDFYIELD, ODDLPRICE, ODDLYIELD, PDURATION, PMT, PPMT, PRICE, PRICEDISC, PRICEMAT, PV, RATE, RECEIVED, RRI, SLN, SYD, TBILLEQ, TBILLPRICE, TBILLYIELD, VDB, YIELD, YIELDDISC, YIELDMAT.

You can also use XIRR and XNPV, but these were already included within the DAX range of functions.

Parts of this blog
Changes in the July 2020 update to Power BI Desktop Using financial functions from Excel in Power BI (this blog) Gradient legends Customisable slicer headers Relative time filters Q + A updates