Blog
Redovito pišemo članke i blogove o tehnologijama Microsoft Business Intelligence. Popis u nastavku prikazuje sav naš sadržaj sortiran kronološki - možete filtrirati sadržaj prema temi posta.
Held PowerApps training for Žito d.d.
Last week we went to Osijek to hold a PowerApps training for Žito d.d. The training took place at the client’s office, lasting 2 days, with a total duration of 8 hours. The participants of the training have been using PowerApps in their business for some time, but they wanted to improve their skills in
New!
DAX Handbook, over 30 articles on the basic and intermediate DAX written in a concise and easy-to-understand way!
Total Articles: 77
Održana PowerApps edukacija za Žito d.d.
Prošli tjedan svratili smo do Osijeka kako bismo održali PowerApps edukaciju za Žito d.d. Edukacija se održala u 2 dana kod klijenta u uredu, u sveukupnom trajanju od 8 sati. Polaznici edukacije već neko vrijeme koriste PowerApps u svom poslovanju, no željeli su usavršiti svoje vještine u samostalnoj izradi aplikacija, kako bi ih kasnije mogli
Prva ovogodišnja PowerApps edukacija za TÜV NORD Adriatic
Prošli tjedan održali smo prvu ovogodišnju PowerApps edukaciju za naše dugogodišnje klijente iz TÜV NORD Adriatic kompanije. Bila je to cjelodnevna edukacija u trajanju od 6 sati, koju je vodio naš PowerApps stručnjak i developer Kristian! PowerApps platforma namijenjena je izradi prilagođenih poslovnih aplikacija i omogućava brzi razvoj aplikacija koje odgovaraju svim poslovnim potrebama. Aplikacije
Održana Excel edukacija za Eksa Grupu
Za kraj godine održali smo Excel edukaciju za naše kolege iz Eksa Grupa d.o.o. Polaznici edukacije u svakodnevnom radu koriste Excel, stoga im je bilo vrlo korisno čuti kako unaprijediti i ubrzati procese obrade i analize podataka. Edukacija je bila prilagođena radu na njihovim stvarnim zadacima te smo prošli kroz razne teme poput unosa ispravnih
Uspješna suradnja s kompanijom MarinExpert u domeni izrade poslovnih aplikacija
Nakon 6 mjeseci intezivne suradnje s rukovoditeljstvom kompanije MarinExpert d.o.o. iz Dugopolja, s velikim zadovoljstvom možemo objaviti da je implementacija sveobuhvatnog aplikativnog rješenja za planiranje i proizvodnju tipiziranih protuprovalnih vrata uspješno dovedena u fazu produkcije! Kako je došlo do suradnje? MarinExpert d.o.o. je jedan od vodećih proizvođača ugostiteljske opreme i protuprovalnih vrata (brand MaxDoor) na
Novi zaposlenik u timu!
Nakon dugog traženja, s velikom radošću objavljujemo da smo zaposlili novog člana i proširili svoj radni tim! Karlo će pojačati naš Power Platform tim u dijelu poslovne analize što podrazumijeva sljedeće tehnologije:Power BI,PowerQuery,PowerPivot/Tabular. Poslovno znanje razvijao je u farmaceutskoj industriji, a uz pomoć našeg iskusnog tima koji je na okupu više od 5 godina, vjerujemo
Gostujuće predavanje na Microsoft 365 konferenciji
Dana 07.11.2024. sudjelovali smo na konferenciji “Tech Event – Microsoft 365” u suradnji s M-San i Callidus grupom. Konferencija je održana u svrhu predstavljanja širokih mogućnosti koje Microsoft 365 platforma nudi u vidu digitalizacije poslovanja, optimiziranju i automatizaciji poslovnih procesa i upravljanju sigurnosnim pitanjima. Naš PowerBI konzultant i trener Krešimir, kao gost predavač, održao je
Total Articles: 21
Dynamic Coalesce in PowerQuery
We can define coalesce in PowerQuery as the last value existing in a single row of multiple columns positioned from left to right. In our example that would be the last value from the month columns. In this article, we will show you how to create both static and dynamic formulas for coalescing. If you
Merging with date range using Power Query
In this blog, we will see how to merge two tables in Power Query based on key column and a date range. Merging with multiple matching columns is straightforward and can be achieved in Power Query by selecting merge queries option and holding CTRL key when choosing matching columns like in the picture below:
Dynamically expand table or record columns in Power Query
In this article, we will show how to solve a common problem of expanding nested tables or records in Power Query, when the column names of the nested objects vary in numbers. In the second part of the article, we will show a more robust technique for dealing with changing structures of the nested tables.
Sorting in Matrix created with calculation groups (PowerBI)
This is the second part of the blog series dedicated to showing workarounds for currently unsupported matrix visual features. In the first part, we explained how to add conditional formatting only for the specified columns. In this article, we will explain how to introduce sorting. Below, you can test a working example in the embedded
Conditional formatting with Calculation Groups in PowerBI Matrix visual
This is going to be the first of 2 articles explaining how to introduce conditional formatting and sorting when using calculation groups in Matrix visual. It would be great if conditional formatting and sorting could be applied to a calculation item, but until this happens, here is a workaround. Link to the second part of
Including hours and minutes in DAX date filters
When filtering data by date, we can simply use a date slicer which is enough in most cases. We rarely need to filter our data by hours and minutes. However, sometimes this approach is necessary for the sake of the analysis. In this blog, we will examine the scenario where we need to include hours
Total Articles: 38
DAX HANDBOOK
7. VARIABLES
Variables are used in almost every measure you will create. The reason we introduce them last is that they use all other parts of DAX code to produce faster, more powerful and maintainable code. Variables are like containers of a part of the DAX code which can be used throughout your measure. Few facts about
DAX HANDBOOK
6.8 ALLSELECTED
Explanation ALLSELECTED is one of the most complex functions in DAX. When used improperly it can lead to unexpected results. As a rule of thumb, you should not use it in iterative functions. It is preferable to use it only as a CALCULATE filter remover, not as a table function. ALLSELECTED comes into play once
DAX HANDBOOK
6.7 Lineage
What is Lineage? Lineage is a part of DAX mechanics that enables us to use tables as filter arguments for the CALCULATE function. It’s also used in row2filter context transition and other aspects of the data model that involve filter propagation throughout the model. We can state that lineage is the possibility to filter the
DAX HANDBOOK
6.6 Crossfilter
Crossfilter is a feature of DAX when it filters the underlying dataset even though there aren’t any visual filters present. Introduction In this example, we will explain a very important feature of CALCULATE filter arguments. We will also explain why you should always prefer the combination of ALL/REMOVEFILTER + VALUES instead of ALLEXCEPT function. We
DAX HANDBOOK
6.5 Expanded tables
When using whole tables as filter arguments to CALCULATE, you are using an expanded version of the model, which consists of the table used in the arguments, as well as all other tables in the data model that are linked to that table through a 1-* relationship. We will explain this concept with a small
DAX HANDBOOK
6.4 CALCULATE order of evaluation
Explanation CALCULATE has an evaluation order different from most other DAX calculations. We can say that it works from outer to inner CALCULATE statements. Let’s explain this with an example: Which value would the SalesMultipleCalculate measure return?a) Blank valueb) 33,702,965 (Black)c) 10,828,592 (Blue) The correct answer is B. Following is the explanation and order of
Total Articles: 14
Dynamic Coalesce in PowerQuery
We can define coalesce in PowerQuery as the last value existing in a single row of multiple columns positioned from left to right. In our example that would be the last value from the month columns. In this article, we will show you how to create both static and dynamic formulas for coalescing. If you
Merging with date range using Power Query
In this blog, we will see how to merge two tables in Power Query based on key column and a date range. Merging with multiple matching columns is straightforward and can be achieved in Power Query by selecting merge queries option and holding CTRL key when choosing matching columns like in the picture below:
How to process multiple folders with a single PowerQuery script
Let us imagine the following scenario. We have multiple clients sharing their sales data with us. They store the data in dedicated folders that reside in different places. The number of clients, as well as the number of files for each client, will vary across periods. We wish to create an automatic refresh system that
Dynamically expand table or record columns in Power Query
In this article, we will show how to solve a common problem of expanding nested tables or records in Power Query, when the column names of the nested objects vary in numbers. In the second part of the article, we will show a more robust technique for dealing with changing structures of the nested tables.
How to track changes in the table in Power Query
If you ever had a need to check if anything changed in the new table compared to the previous export, no matter in which column, then this is the article for you. We have created an M script in Excel that uses the left anti join to check for data inconsistency. it works with any
Split packs into single products in Power Query
This is going to be an easy-to-follow article on how to use PowerQuery to easily change source data granularity for only a subset of data. We used a client’s request to split packs into its components as an inspiration to write this post. You can also download Excel workbook and follow along. Sometimes in the
Total Articles: 3
Dynamic bulk insert to Power Apps collection
In one of our latest blog posts, we described a technique used to copy tables from other programs (e.g. Excel) into PowerApps collections. This solution had a drawback. Within the code, the column order was referenced to determine which column to collect. This means that, for the first column in the PowerApps collection, it gets
Bulk insert to Power Apps collection
In this blog, we will show you the technique used to collect tables for your app by using the bulk insert. We will show you how to make the same table structure in Power Apps as Excel tables. We will use Excel to show you how to copy-paste tabular data from it and collect it
Why should you start using Power Apps?
In this article, we will take a look at what is Power Apps, why should we use it, and when organizations can benefit from custom apps created in the Power Apps platform.Many organizations are not yet familiarized with Power Apps capabilities, and the ways it can improve their agility, modernize and automate manual processes. What is Power Apps? The official Microsoft
Autori
Krešimir Ledinski
Microsoftov certificirani stručnjak u području poslovne inteligencije. Najveće su mu strasti DAX, M i modeliranje podataka.
Kristian Radoš
Iskusni analitičar podataka. Napredan u SQL, PowerApps i M jeziku.
