Forum Discussion
Solved
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...
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 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 to
Table1 = dba{[Name= if parameter="blank" then "table1" else "table1" & parameter ,Kind="Table"]}[Data],....
