Forum Discussion
insert empty value in parameter power query
Hello,
i would like to add a paramater in power query with list of value like _dev and empty value
when i select dev in my parameter i will have my table like this : table_dev
i when i select empty value i will have table
i tried with null, "", '', blank with no success 😞
Do you know how to do it ?
Best regards
I am assuming you want to return 'table1' if 'Blank' is selected with the parameter and 'table1_dev' if '_dev' is selected.
In that case you would need to change your code toTable1 = dba{[Name= if parameter="blank" then "table1" else "table1" & parameter ,Kind="Table"]}[Data],....
5 Replies
You cannot have a blank value in the parameter list.
To workaround you can add 'Blank' to the parameter list and then use an if statement to ignore the parameter if 'Blank' is selected.I am assuming you want to return 'table1' if 'Blank' is selected with the parameter and 'table1_dev' if '_dev' is selected.
In that case you would need to change your code toTable1 = dba{[Name= if parameter="blank" then "table1" else "table1" & parameter ,Kind="Table"]}[Data],....
I'm interested if you have any ideas
