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»
Software
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»
Find and close the process with Linux console
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. Read more»
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»
Debug only Your Code – Enable Just My Code in VS 2022
Today I will write about a very important option in VS 2022, which is called ‘Enable Just My Code’. I don’t really know, why is set so. In my opinion, almost all the developers update this value after installation of Visual Studio. Read more»
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»
Virus like ‘Windows defender’ in Germany
Recently I met a new kind of screen locker while browsing. I could see it with Chrome and Edge in Windows 11. It opens a window which looks like a Windows defender and tells you to call to a number of the support. Of course, you will just pay too much for this call and […] Read more»
Write Number as it is in Microsoft Power BI Desktop widget
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. Read more»
Execute Jenkins Docker image at Windows 11
I often use docker at my workstation. It’s very comfortable. It’s already too much written about it, I won’t repeat. And let everyone choose what he wants. Read more»
Add the application as a service at Windows Server
You can add the service with PowerShell. New-Service and Get-service are available in PowerShell 5, for ‘Remove-Service’ PowerShell >= 6 required. Otherwise you can use ‘sc.exe DELETE MyMegaServiceApplication’. You should execute it with as an administrator. Not any application you can start a service. As a .Net developer, I usually create .Net solutions, in this […] Read more»