We have a table in word document and now we need to add new rows from the existing text. The text was copied from the text editor Notepad.

Standard deviation is the degree of dispersion or the scatter of the data points relative to its mean, in descriptive statistics. It’s often used in data analysis and reports. And, of course, how to calculate Standard deviation in PowerBI is very important to know.

I parsed the CSV file. The lines are separated by '\r\n'. If in Flow you use split(text, '\r\n'), it doesn't work as you'd like to. Instead use function decideUriComponent and respective values: \r - %0D, \n - %0A

There are 2 languages in PowerBI - M and DAX. M is for data loading and DAX is for further data transformation.

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.

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.

To add the arrows UP and DOWN for a visualization of data changes in Power BI report, you can use this DAX function. It can help you to make a table more descriptive.

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.

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:

1. Select a range of cells.
2. Right click on the selected cells and then choose Format Cells (Figure 1)
3. Go to the Alignment tab and check the checkbox "Merge cells" (Figure 2).

The other way to merge cells in Excel is via Excel Ribbon. This way is one step less. (read more...)