Hi,
I have a sql query stored in power query.
I have managed to change some of the settings of that query with values from the excel sheet.
For instance I stored a value 1, or a text chain in excel cell so that I can update my query without using VBA.
However, some of the parameters I need to change have the value "is null" or "is not null".
Can anyone tell me how to do?
I would like to create a drop down list with isnull or is not null and when I change the value to one or another one, it updates my sql query.
Thanks for your help.
I have a sql query stored in power query.
I have managed to change some of the settings of that query with values from the excel sheet.
For instance I stored a value 1, or a text chain in excel cell so that I can update my query without using VBA.
However, some of the parameters I need to change have the value "is null" or "is not null".
Can anyone tell me how to do?
I would like to create a drop down list with isnull or is not null and when I change the value to one or another one, it updates my sql query.
Thanks for your help.