Forum Discussion
Using variables in Power Query
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.
Community ChampionAnonymous - 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.