Forum Discussion

hi_world's avatar
hi_world
Icon for Helper III rankHelper III
3 years ago
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...
Need Help
Show and Tell
  • jgeddes's avatar
    jgeddes
    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 to 

    Table1 = dba{[Name= if parameter="blank" then "table1" else "table1" & parameter ,Kind="Table"]}[Data],....

hi_world's avatar
hi_world
Icon for Helper III rankHelper III
3 years ago

hello 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's avatar
jgeddes
Icon for Super User rankSuper User
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 to 

Table1 = dba{[Name= if parameter="blank" then "table1" else "table1" & parameter ,Kind="Table"]}[Data],....

  • hi_world's avatar
    hi_world
    Icon for Helper III rankHelper III
    3 years ago

    Thank you so much jgeddes