power bi

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

Get the Quarter of the Year in PowerBI

There are 2 languages in PowerBI – M and DAX. M is for data loading and DAX is for further data transformation. Read more»

Microsoft Office

PowerBi. Concatenate table rows in one string

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»

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

PowerBI. Add the arrows UP and DOWN

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

Microsoft Office

Popular Posts