Forum Discussion
hi_world
Helper III
3 years agoinsert 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...
- 3 years ago
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],....
hi_world
Helper III
3 years agoI'm interested if you have any ideas