Forum Discussion
Helper IIIinsert empty value in parameter power query
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],....
Super UserYou 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.
hi_worldhello jgeddes
thank you for your reponse.i tried this :
Table1 = dba{[Name="table1"& if parameter="blank" then "" else parameter ,Kind="Table"]}[Data],....
but id doesn't work 😕
thank you for you help- jgeddes
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],....