There are 2 languages in PowerBI - M and DAX. M is for data loading and DAX is for further data transformation.
(read more...)There are 2 languages in PowerBI - M and DAX. M is for data loading and DAX is for further data transformation.
(read more...)If you want to make a string of values in Power BI, you can use the formula like this. It will join all the values, which correspond to the condition, in one line.
(read more...)PowerBI applies a lot of functions automatically or you can make them manually. But if you work with a dynamically changed data, for example, when new columns are added in SharePoint list, and you don’t want to add them manually every month (week, year, etc), you can automatically iterate through them.
(read more...)In Microsoft Power BI Desktop it’s not obviously how to write a Number as it is without modifications like to write ‘2k’ instead of ‘2023’. Truth be told, it took me approximately 5 minutes to do it.
(read more...)Word allows you to create a Table of Contents automatically. It searches headings in your document and creates contents according to them. Headings must be set via headings styles in tab "Home". (read more...)
You can merge Excel cells in 3 simple steps:
The other way to merge cells in Excel is via Excel Ribbon. This way is one step less. (read more...)
Excel has a huge number of tools for customizing text and tools to count data. So, one of useful things is to rotate text on any angle. It can be useful for customizing table headers. (read more...)
During long use of Microsoft products, I got a habit that to update Microsoft Office I need to download Service Pack for my MS Office version. But in MS Office 2013 I can easily press some buttons for updates.
When you work in Excel with large tables, for example, price list, sometimes while scrolling you forget what columns you are watching. To make more comfortable work with tables you can fix position of cells (row or column) so that other cells to be scrolled and the cells with names are fixed. (read more...)