Hi There,
I have several workbooks that refer to a BI power query.
The data queries a data large table. I'd like to add a "where clause" (SQL speak) or similar to restrict the query to only bring back the information in column 1. Column 1 is the job number that is defined in the NAMES region of the workbook (using Names Manager functionality).
Rather than hard coding the job number, is there a way to call the defined name?
I have several workbooks that refer to a BI power query.
The data queries a data large table. I'd like to add a "where clause" (SQL speak) or similar to restrict the query to only bring back the information in column 1. Column 1 is the job number that is defined in the NAMES region of the workbook (using Names Manager functionality).
Rather than hard coding the job number, is there a way to call the defined name?
