Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric certified for FREE! Don't miss your chance! Learn more

Invoke Custom Function - Required Functionality

The newly introduced Invoke Custom Functions does not support calculations. When calling a Power Query implementation of the Excel PMT Function I need to pass a computation e.g. [Term] * 12 as a parameter. fnPMT([Bank Loan], [#"Interest %"], 12, [Term] * 12 ) The new UI only supports Decimal Number OR Column Name ... what is required is a combination of the two. It is now necessary to invoke the Advanced Editor in order to make the necessary adjustment.
Status: Needs Votes
Comments
fbcideas_migusr
New Member
Status changed to: Needs Votes