564 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
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.
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:
You can also use XIRR and XNPV, but these were already included within the DAX range of functions.
|Parts of this blog|
25 Aytoun Street