Set parameter equal to a specific value in a table

[joekoshar]

I have a data source in Excel where the title of the file changes daily. I have a separate table (Table1) that has the name of the new name of the file. How can i set a parameter to a single value within a table? 

Say for example the parameter must be set to the 2nd column, 4th row of Table1

[v-shex-msft · Accepted solution]

Hi @joekoshar,

Actually, you can use '[]' and '{}' with query table to find out specific cell value.

For example: 2nd column, 4th row of Table1

Custom = Table[Column2]{3}

Reference link:

M Operators

Regards,

Xiaoxin Sheng

[LivioLanzo]

@joekoshar

Check this out: https://www.excelguru.ca/blog/2014/11/26/building-a-parameter-table-for-power-query/