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.

I had a SharePoint online list and I added a new column into it. And then I wanted to work with a data, which is close to be real. So I needed to generate the data and insert it into the list. For the tasks like this I like to use division by module to create semi-random data.

Linux 'netstat' command finds out which process is listing upon a port. Obviously, you usually need it when something doesn't allow to start/restart an application or docker.

How to store credentials? It’s always a question because nobody wants to demonstrate the passwords, neither for the databases, nor for web services or anything else. SharePoint has a built-in tool to store a sensitive data – technical user accounts, databases or any data like this.  Here is how to create variables in the secure store.

Nobody can't work all day, you need to have a rest. And also, you should laugh, because it extends your life. Here are the coding jokes which I like (and remember)

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.

Class to determine if a user is in the SharePoint group or is in the AD Group, which is added to the SharePoint group. So, the admin access to a custom SharePoint module is that everybody, who exists in the admin group, has more data. The admin group is a SharePoint group, which contains SPUsers (from domain) and Domain groups, which contain AD Users. Actual for SharePoint 2016, 2019.

Obviously, true developers prefer to return the date in a digital format, for example, '24.01.2024', '24-01-2024' and various combinations of this. But customers often want to work with human dates. In this post you can find how to return the custom localized date and how to use it with a Fluent-UI component DatePicker.

In apps with different Roles and permissions you may need to get information about AD Groups. Here are some snippets which can help you with this part of the task.