ExcelChamp PowerBI Tip #2: Use Query Results in Another Query Using Reference Query Option
It is much easier to use the results of an existing query rather than duplicate the query and waste processing resources in repeating the steps again and again.
You can simply use the results of a query to create a new query. This can be useful when you want to combine two different tables into a third table, but you do not want to modify or merge the 2 ORIGINAL Tables in Power Query.
Watch this simple PowerBI Tip Video to learn about Reference Queries.
Video Tip Created by Vinai Prakash,
Founder: ExcelChamp.Net & Intellisoft Systems
https://www.ExcelChamp.Net | https://www.intellisoft.com.sg
========================================
Support Us: https://tinyurl.com/ExcelChamp
========================================
Learn this nifty trick from ExcelChamp Founder Vinai Prakash.
You can reach Vinai Prakash to conduct a Excel Training for your company - via classroom, or virtually over zoom. Connect with Vinai on LinkedIn at / vinaiprakash
For more such tips, visit our blog, full of Excel goodies to make you awesome in Excel: https://www.excelchamp.net
#ExcelChamp #ExcelTips #ExcelTricks #MicrosoftExcel #ExcelChampVideos #BestExcelTips
=========================================================================