Unija Računovodska hiša Logo
Contact us

Send
inqury

Knowledge base

home banner

bi@unija.com
Contact us

  • Knowledge

  • Categories

November 27, 2020

Unpivoting Data

Author: Branka Trifunović

For Power BI version 2.76.5678.782 (December 2019). Unpivoting data is a problem we can encounter when shaping data. Data is often distorted in one way or another. One daunting problem is data that’s already pivoted, like in the example below.
More ...

August 28, 2020

Power Query: M functions

Author: Branka Trifunović

For Power BI version 2.76.5678.782 (December 2019). M language enables us to create powerful transformations in Power Query editor. We use custom functions for steps that repeat often in data editing. We already saw how to create custom function in
More ...

August 14, 2020

Introduction to M language

Author: Branka Trifunović

For Power BI version 2.76.5678.782 (December 2019). Query editor is a capable data editor in Power BI Desktop. Transformations made in Power Query are written in M language. Understanding M is not necessary, but can be a powerful asset for
More ...

August 7, 2020

Power Query objects

Author: Branka Trifunović

For Power BI version 2.76.5678.782 (December 2019). Power Query knows several types of objects. Queries can be of type table, list, row or function. Let’s look at how we create different types of objects and convert between them. Tables Tables
More ...

July 31, 2020

Appending Queries

Author: Branka Trifunović

For Power BI version 2.76.5678.782 (December 2019). Every Power BI project starts with many queries. Whenever possible, we append queries. We always work toward a star schema, meaning one large fact table and several smaller dimension tables. More on star
More ...

July 15, 2020

Dynamic filtering using a list in Power Query

Author: Branka Trifunović

For Power BI version 2.76.5678.782 (December 2019). In shaping data, we often need to compare two tables and filter one based on the other. In this article we’ll show how to remove the rows from a table, that appear in
More ...

June 14, 2020

Dynamic Removal of Rows in Power Query for All the Files in a Folder

Author: Branka Trifunović

In this article we’ll remove unnecessary rows for all the files inside a folder and merge them in one single table. Data files often contain metadata like time of creation, location, author, etc. Metadata usually takes up the first few
More ...

June 14, 2020

Dynamic Removal of Rows in Power Query

Author: Branka Trifunović

In this article we’ll see how to remove appropriate number of irrelevant rows in Power Query editor. We often work with data that starts with description like time of creation, location, author, etc. This metadata usually takes up first few
More ...

June 14, 2020

Create a Dynamic Calendar in Power BI

Author: Branka Trifunović

In this article we’ll cover how to create a dynamic calendar in Power BI, using the Power Query Editor. Calendar table is the most important table in Power BI model. We use it to connect to big fact tables and
More ...

Vsebina za iskani kriterij ne obstaja.