Unija Računovodska hiša Logo
Contact us

Send
inqury

Knowledge base

home banner

bi@unija.com
Contact us

  • Knowledge

  • Categories

September 25, 2020

Context Transition in Power BI

Author: Branka Trifunović

For Power BI version 2.76.5678.782 (December 2019). Filter context, row context and context transition from row to filter context are most challenging topics when learning DAX. We have already talked about filter and row context in previous articles Filter Context
More ...

September 18, 2020

Row Context in Power BI

Author: Branka Trifunović

For Power BI version 2.76.5678.782 (December 2019). Row context is a property of calculated columns and some functions of being aware of rows within calculations. Row context means that the function travels through every row separately. Expression is calculated for
More ...

September 11, 2020

Filter Context in Power BI

Author: Branka Trifunović

For Power BI version 2.76.5678.782 (December 2019). Understanding filter context is key when working with Power BI. Filter context and context propagation are important concepts we have to understand, if we really want to understand DAX. Initial filter context Initial
More ...

September 4, 2020

Implicit and Explicit Measures in Power BI

Author: Branka Trifunović

For Power BI version 2.76.5678.782 (December 2019). Measures Measure is a formula that tells Power BI what to do with data. Most often measures are aggregations, for example sum, average, count, etc. Power Bi knows implicit and explicit measures. We
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 ...

Vsebina za iskani kriterij ne obstaja.