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.

  • ALL
  • POWERBI
  • DAX
  • POWER QUERY

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...

Read More

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...

Read More

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...

Read More

How to split budgets to lower granularity with DAX (PowerBI)

When creating a budgeting prediction, most of the time we are creating it on the higher granularities. Rarely we do it on a daily basis. But sometimes we are required to match budgets to actual sales on lower granularities than the one we previously set (e.q. the manager wishes to...

Read More

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...

Read More

How to split budgets to lower granularity with DAX (PowerBI)

When creating a budgeting prediction, most of the time we are creating it on the higher granularities. Rarely we do it on a daily basis. But sometimes we are required to match budgets to actual sales on lower granularities than the one we previously set (e.q. the manager wishes to...

Read More

PowerBI One Measure for Multiple Dimensions/Facts – DAX

In this article, we will see how to combine different dimensions and facts inside a single matrix table visual. This approach helps us create fewer measures and tables, but at the same time, it provides us with greater design possibilities, like conditional formatting across the whole column even though there...

Read More

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...

Read More

How to split budgets to lower granularity with DAX (PowerBI)

When creating a budgeting prediction, most of the time we are creating it on the higher granularities. Rarely we do it on a daily basis. But sometimes we are required to match budgets to actual sales on lower granularities than the one we previously set (e.q. the manager wishes to...

Read More

PowerBI One Measure for Multiple Dimensions/Facts – DAX

In this article, we will see how to combine different dimensions and facts inside a single matrix table visual. This approach helps us create fewer measures and tables, but at the same time, it provides us with greater design possibilities, like conditional formatting across the whole column even though there...

Read More

Dynamic ABC analysis in DAX-variables

ABC analysis is one of the most commonly used categorization techniques. This technique divides subjects of analysis (Products, Customers, Inventory, etc.) into different categories based on subject importance. The analysis is based on the Pareto principle which states that the most economic productivity comes from only a small part of...

Read More

How to use Measures in Excel

Measures are with us since the Excel 2010, yet I’ve seen only a few people using them while doing analysis or data manipulation in any way. To use Measures in Excel 2010, you first needed to install PowerPivot add-in, since it is not a part of the application itself. Formulas...

Read More

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...

Read More

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...

Read More

The next generation of data analysts

So far I have written a couple of articles about PowerPivot, PowerQuery, and DAX. The reason I started my blog with these topics, and will continue to do so, was to get you all familiar with “New” technologies that are coming our way and that are redefining our understanding of...

Read More

Autori

Krešimir Ledinski

Krešimir Ledinski

Microsoftov certificirani stručnjak u području poslovne inteligencije. Najveće su mu strasti DAX, M i modeliranje podataka.

Kristian Radoš

Kristian Radoš

Iskusni analitičar tehnologije i podataka. Napredno u SQL, PowerApps i M jeziku.

SUBSCRIBE TO NEWSLETTER

Receive latest updates on all business analyst news across all platforms.
Scroll to Top