Forum Discussion
arpost
3 years agoPost Prodigy
Anyone know how to create a custom function with optional values in the query itself?
Greetings, community. Have a problem and am hoping a Power Query/M guru out there can help me. I'm trying to create a custom function from a query and cannot figure out how to make it so any para...
gafoorgk
1 year agoFrequent Visitor
I was going to ask the same question, then found this post where no one answered. Seems this is not possible in Power Query even when a parameter is created with 'Required' option is turned off. Only option is to break the connection. That would make updating function a bit tedious process.