invoke custom function
1 TopicExpression.Error: We cannot convert the value "[Function]" to type Function
I have a report that I'm converting to a PBIT and then moving to another location to create a PBIX. This will involve changing some parameters to connect to other data sources. I'm getting a problem with one query. I have a table where I've added columns using "Add Column" "Invoke Custom Function" This works in the original report. But when I try to run the query in the PBIX imported from the PBIT file, I get this error: Expression.Error: We cannot convert the value "[Function]" to type Function. Details: Value=[Function] Type=[Type] This seems to be a type mismatch but I can't figure out why or how to fix it. I created the column usign the dialog to select my fuction and it's arguments. The statement is: = Table.AddColumn(#"Changed Type", "Prior Visit", each PriorVisitIEN([EPI], [IEN])) where PriorVisitIEN is the name of a custom function in the current file. I've tested it, and it works and the arguments are the right types. Any clues will be greatly appreciated. Thanks !4.6KViews2likes6Comments