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.
1 Comment
- Status added:Needs Votes
