by Nikolai Pavlov | Apr 17, 2020 | Video
In this video, we will show you how to append multiple Excel files from one folder in Power BI using Power Query. Finance professionals regularly put together weekly and monthly reports. When a new month comes out, many still do it manually. They copy and paste the...
by Nikolai Pavlov | Apr 14, 2020 | Video
In this video, we will learn how to create relationships between tables as part of a data modeling process in Power BI. Many business users rely on Excel’s powerful VLOOKUP function to pull information from different tables and sheets. This is an important step before...