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.

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.

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.