Unija Računovodska hiša Logo
Contact us

Send
inqury

Knowledge base

home banner

bi@unija.com
Contact us

  • Knowledge

  • Categories

January 13, 2021

R and Power BI – Dates

Author: Branka Trifunović

For Power BI version 2.76.5678.782 (December 2019). Working with dates with Power BI requires an extra steps, since R doesn’t recognize date data automatically. Let’s look at the following example. We have a table with columns Date and Price. Column
More ...

December 18, 2020

R and Power BI – Introduction and Examples

Author: Branka Trifunović

For Power BI version 2.76.5678.782 (December 2019). R is a programming language for statistical analysis of data. It’s open source and supported with over 15 000 packages, covering specific areas. Alongside powerful packages it provides print quality visualization of data.
More ...

November 20, 2020

DAX function VALUES, HASONEVALUE

Author: Branka Trifunović

For Power BI version 2.76.5678.782 (December 2019). Function VALUES() Function VALUES() returns a column of unique values. Function takes in initial filter context that comes from visualizations and slicers. You can find more on filter context in Filter context in
More ...

November 13, 2020

DAX function SWITCH

Author: Branka Trifunović

For Power BI version 2.76.5678.782 (December 2019). Function SWITCH() reads the value of the expression, compares it and returns a result from a pre-defined list. It is a key function used with unconnected table. Syntax SWITCH(Expression, Value1, Result1 [, Value
More ...

November 6, 2020

DAX function IF

Author: Branka Trifunović

For Power BI version 2.76.5678.782 (December 2019). Function IF() evaluates the expression to TRUE or FALSE and returns the value specified for each outcome. Syntax IF(LogicalTest, ValueIfTrue, [ValueIfFalse]) Parameter Description LogicalTest Expression evaluated as TRUE or FALSE ValueIfTrue Value returned
More ...

October 30, 2020

DAX function FILTER

Author: Branka Trifunović

For Power BI version 2.76.5678.782 (December 2019). FILTER() is a function that filters a table and returns the remaining rows. It is similar to function CALCULATE(). The difference is FILTER() returns a filtered table and CALCULATE() returns value of the
More ...

October 23, 2020

DAX function CALCULATE

Author: Branka Trifunović

For Power BI version 2.76.5678.782 (December 2019). CALCULATE() function is the most important function in DAX language. It’s almost the only function that can change the filter context coming from visualizations. You can read more on filter context in articles
More ...

October 9, 2020

X-functions in DAX

Author: Branka Trifunović

For Power BI version 2.76.5678.782 (December 2019). X-functions in DAX are iterator functions. This means they are aware of rows. For example, function SUMX() calculates the sum of expression for each row separately. You can find more on row context
More ...

October 2, 2020

DAX functions

Author: Branka Trifunović

For Power BI version 2.76.5678.782 (December 2019). Let’s look at the most common functions we use when working with DAX. All functions in this article (except for the function DIVIDE) are aggregator functions. This means they take a column (or
More ...

July 15, 2020

Row-level security in Power BI

Author: Branka Trifunović

For Power BI version 2.76.5678.782 (December 2019). When handling data we need a system for handling user’s rights. We usually don’t want users to access entire database tables. Row-level security controls access at a row level. We can restrict access
More ...

June 15, 2020

5 best practices for data modeling

Author: Branka Trifunović

For Power BI Desktop version 2.76.5678.782 (January 2020). Data model is the core of every Power BI project. Building a good data model is crucial. In this article, we present 5 best practices to make sure your data model runs smoothly.
More ...

June 15, 2020

Time Functions in DAX Language

Author: Branka Trifunović

For Power BI Desktop version 2.76.5678.782 (January 2020). Time functions in DAX language enable us to filter data to a particular date, period between two dates, Year to Date and similar. Time functions only work if we have a set calendar
More ...

June 15, 2020

Monthly and YTD Slicer in Power BI

Author: Branka Trifunović

For Power BI Desktop version 2.76.5678.782 (January 2020). We usually want to track business data like revenue, plan and forecast on a monthly or YTD basis. YTD or Year to Date is a function, that aggregates data from the beginning of
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

Dynamic Calendar in Power BI with CALENDARAUTO()

Author: Branka Trifunović

In this article we’ll create a dynamic calendar in Power BI using CALENDARAUTO() function. Calendar is the most important table in Power BI data model. We have seen how calendar table looks in our Calendar in Power BI article. We
More ...

June 14, 2020

Dynamic Calendar in Power Query Using an M Function

Author: Branka Trifunović

In this article we’ll create a dynamic calendar in Power Query editor, using a function written in M language. Calendar table is the most important table of Power BI model. We have seen how it looks in our Calendar in
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.