Using variables in Power Query

[Anonymous]

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!

[edhans · Accepted solution]

@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.