Daily DAX : Day 28 XNPV

 A Financial DAX function that returns the Net Present Value of a schedule of cash flows


Syntax


XNPV(<Table>, <Values>, <Dates>, <Rate>)


where table is the table that has the row whare values and dates expression will be evaluated

An expression at the row level that will yield the cash flows

An expression that will yield a schedule of  payment dates

Rate is the discount rate to be applied to the cash flows


https://dax.guide/xnpv/

Comments

Post a Comment

Popular posts from this blog

Daily DAX : Day 65 INFO.TABLEPERMISSIONS

 A metadata DAX function that returns a list of all table permissions in the current model with columns matching the schema rowset for table permissions objects Syntax INFO.TABLEPERMISSIONS(<RestrictionName>,<RestrictionValue>) Returns a table with the following fields Field Type ID Integer RoleID Integer TableID Integer FilterExpression String ModifiedTime DateTime State Integer ErrorMessage String MetadataPermission Integer https://dax.guide/info-tablepermissions/
Read more

Daily DAX : Day 55 PV

A financial DAX function that calculates the present value of a loan or an investment, based on a constant interest rate. You can use PV with either periodic, constant payments (such as a mortgage or other loan), or a future value that’s your investment goal. Syntax PV(<Rate>, <Nr_of_Periods>,<Payments_per_period>,<Future_Value>,<Type>) https://dax.guide/pv/
Read more