How old is the owner of JMBG?

The unique identity number of citizens (JMBG) was created in the Socialist Federal Republic of Yugoslavia, and is still used today in the Republic of Serbia, for the purpose of identifying citizens. It is a mandatory datum in the identity card, driver’s license, health card, passport and all other important documents. Its first 9 digits indicate the date of birth. How to calculate the age of the JMBG holder based on this data?

Office Scripts

For years, Microsoft has been trying to replace VBA (Visual Basic for Applications), the programming language that “lives” in the background of Excel. As they say, the reasons are of a security nature. This is not entirely without merit, but it seems to me that the motive of the Excel development team, to a greater extent, was to create scripts that would fit better into the Microsoft 365 and Power Platform ecosystem. Whether they succeeded in this is up to you to try.

Microsoft Fabric

Microsoft Fabric represents an end-to-end analytical solution that combines Power BI, as a reporting platform, Data Factory, as a data integration service, as well as Microsoft Synapse Data Engineering, Data Warehousing, Data Science and Real Time Analytics. It is designed as a software as a service solution, and the data is stored within the OneLake repository, which enables the storage of structured and unstructured data…

New Card visual

Card is a visualization that is often used in Power BI reports to display some static data, for example: total revenue, total costs, profit, number of employees… This visualization has not changed since the beginning, and since a few months ago Card (new) visual appeared, which has all the functionality of Card and some new features. First, it offers easy simultaneous display of several indicators, and then there are numerous options for their formatting…

On-object interaction

The simplest way to modify Excel charts and add new elements is by using the menu displayed in their upper right corner. Based on this functionality, Power BI received an option for modifying and formatting visualizations, which is called on-object interaction. It enables easy addition, modification and removal of report dimensions and other display elements, as well as customization of the appearance of the visual…