By god almighty, i haven't found a single way to edit this function.... Its called from SQL through VBA, when you open SQL in excel it is defined as a formula, but clicking on it only allows me to fill specific parameters. Trying to edit on query it only opens a function that calls that very same item, instead of editting it. }[Data], dbo_fnVendasMes = dacoes{[Schema="dbo",Item="fnVendasMes"]}[Data], #"Função Invocadadbo_fnVendasMes1" = dbo_fnVendasMes(null, null) in #"Função Invocadadbo_fnVendasMes1" ] I can't google because i have not found a name for this funcion that doesnt guide me to the above function change instead of changing the item/funcion thats been called

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

SQL functions editting

Thread starter arthur_w
Start date Apr 13, 2022
Tags

power querry; sql

arthur_w

New Member

Apr 13, 2022

By god almighty, i haven't found a single way to edit this function....
Its called from SQL through VBA, when you open SQL in excel it is defined as a formula, but clicking on it only allows me to fill specific parameters.

Trying to edit on query it only opens a function that calls that very same item, instead of editting it.

Code:

}[Data],
    dbo_fnVendasMes = dacoes{[Schema="dbo",Item="fnVendasMes"]}[Data],
    #"Função Invocadadbo_fnVendasMes1" = dbo_fnVendasMes(null, null)
in
    #"Função Invocadadbo_fnVendasMes1"
]

I can't google because i have not found a name for this funcion that doesnt guide me to the above function change instead of changing the item/funcion thats been called