transform data

Hotkeys to transform text to UPPERCASE or to LOWERCASE in Visual Studio and Visual Studio Code

Transform text UPPERCASE or lowercase is a very common task for a developer. And when the text is not in the required case, you obviously don’t want to type it one more time. Luckily, there are the developers of Visual Studio who already thought about it. Read more»

Windows

The Implementation of STDEV for values from 3 columns in the table

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. Read more»

Microsoft Office

Iterate table columns in PowerBI data transformation

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»

Microsoft Office

Popular Posts