Appending Multiple Files
In this lesson, you will learn different techniques to combine files (.CSV, Excel) into a single table.
In this lesson, you will learn different techniques to combine files (.CSV, Excel) into a single table.
In this lesson, you will learn how to import multiple worksheets (tabs) and how to combine the multiple sheets into a single query.
In this lesson, you will learn how to create a Calendar table from scratch and generalize it so that it starts from a specified date and ends with the current date.
In this lesson, you will learn the concept - Self-referencing Tables. This is used in adding comments to tabular data and retaining them in place when data manipulations are done on the table.
In this lesson, you will learn how to use parameters in Power BI Desktop and how to use parameter tables in Excel.
In this lesson, you will learn how to import tabular data from a PDF file to Power BI Desktop, provided the PDF file is not password protected and the data is in tabular format. You will also learn how to combine multiple sets of columns to a single set of columns.