BI poduzeće specijalizirano za PowerBI / PowerApps / Excel

Više od 20 domaćih i stranih klijenata
Implementacija PowerBI rješenja i edukacija

List.Generate() and Looping in PowerQuery

In this blog, we will explain an advanced topic about the M language – using List.Generate to loop over a table. We will combine our knowledge of lists, records, functions, iterations, and looping techniques. Basically, every important object in PowerQuery. Do-while Loop in PowerQuery Do while loop is commonly used...

Pročitaj više

Using M to dynamically change column names in PowerQuery

In this article, we are going to talk about cleaning and transforming column names dynamically and in a bulk. The article was inspired by a request from a client who had issues exporting data from its data warehousing program to .csv files. Out of an unknown reason, program was adding...

Pročitaj više

Pivottables inside the PowerBI – The DAX way

PivotTables, or pivoting, is by far the best analytical power of Excel. You digest the data and play with it on the fly. Heck, PowerBI is pretty much PivotTables with pretty visuals, just a lot smarter (because of DAX). While PowerBI offers many stunning looking visuals including matrices, they do...

Pročitaj više

POSJEDUJEMO

Microsoft certifikat za BI reporting

8+ GODINA

Korištenja modernih Microsoft alata za obradu i analizu podataka (PowerQuery, DAX).

4+ GODINE

Iskustva u radu unutar PowerBI okruženja.

VIŠE OD 20

Zadovoljnih domaćih i stranih klijenata

Učite uz Exceed akademiju

Unaprijedite svoje vještine obrade izvještaja uz Exceed akademiju. Sadržaj je prilagođen i za početnike i za profesionalce.

Scroll to Top