Скачать с ютуб Query Variables в хорошем качестве

Query Variables

Let's say we are building a query to clean up and prepare some data for use, and we have a specific value we need to use within the query. But, what happens next period when we need to update the value? One option would be to update that value manually in the query editor. But, that is kind of cumbersome. Another option would be to create a variables table in Excel, and just manage the value there. This video demonstrates how to create a variables table and use with Power Query. Written tutorial and sample file: https://www.excel-university.com/quer...