Ted Murphy on 01 Oct 2016 18:57:14
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.