Until now we used Text Import Wizard to import text, and nowadays we can achieve the same result, whether it’s TXT or CSV files, with two new functions: IMPORTTEXT and IMPORTCSV. These functions are very similar: the first one offers more features, while the second is intended exclusively for importing from CSV files. Both functions return a dynamic array, are easy to use, and can make it much easier to import data.
When you create formulas in Excel, you can refer to cell addresses, and you can also name cells or ranges by using the Name Manager to create the appropriate names. Can names be created automatically? Yes they can! After selecting a range, and giving a criterion in the Create from Selection option, you can create names automatically…
Since 2018, Excel has undergone one of the biggest transformations in its history with the introduction of functions for working with dynamic arrays. Unlike traditional functions that return a single value, these functions can generate entire tables as a result. Because these tables are dynamic, any change to the data in the source is automatically reflected in the displayed result. How to format dynamic results?
Slicers are graphical objects that we can use to filter data on a Power BI report page. When we use the dates to create slicers, then we create the so-called Timeline slicer. Until now, we were able to manually select a date range to filter the data in the report, and recently it is possible to run a Date Picker control in order to chose a date within a slicer.
If you’re creating a Power BI report that consists of multiple pages, it’s a good practice to add a navigation menu to its header. Previously, this was achieved by adding multiple buttons, assigning links to each of them that lead to the corresponding pages, and then grouping them into a single menu. Today, there is a much simpler way to achieve this, and recently it is also possible to define a landing page.