Forum Discussion
Using variables in Power Query
Hello!
I want to maintain a list of variables in Power Query:
Text1
Text2
etc
I want then to feed each of these variables to specific positions in my Power Query code, how can I do that please?
E.g. the Text1 can be used as a part of a filename or filepath or worksheet name etc.
If you also have some easy documentation how to loop through the variables list and execute a particular Power Query using each of the variables in the list at a time, that would also be interesting!
Thanks!
Anonymous - see this blog post on including refresh timestamps in your report. I include the use of variables like this. I always name my variables varSomething so you can see what they are. These variables are inline - in one query, but can just as easily be produced by other queries that resolve to a scalar value.
Using List.Contains To Filter Dimension Tables — ehansalytics is another article I wrote where one query creates a variable that is a list of items, then that list is used in another query.
1 Reply
Anonymous - see this blog post on including refresh timestamps in your report. I include the use of variables like this. I always name my variables varSomething so you can see what they are. These variables are inline - in one query, but can just as easily be produced by other queries that resolve to a scalar value.
Using List.Contains To Filter Dimension Tables — ehansalytics is another article I wrote where one query creates a variable that is a list of items, then that list is used in another query.