VIDEO: Creating the Calendar Table in Power BI

VIDEO: Creating the Calendar Table in Power BI

In this video, we discuss the calendar table in Power BI. When building a report in Power BI, it is recommended to create a calendar table. The calendar helps to better organize data and perform a more in-depth analysis using time-intelligence functions. In this...
VIDEO: Creating the Calendar Table in Power BI

VIDEO: Why and When Merge Queries in Power Query

In this video we will discuss when and why merge queries in Power BI using Power Query editor. Combining queries is one of the most essential tasks in Power BI. There are two options to combine queries: the append and merge functions in Power Query. In our last video...
VIDEO: Creating the Calendar Table in Power BI

VIDEO: Append Multiple Excel Files From One Folder

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