# Knowledge base

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

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

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

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

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

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

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

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

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

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

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

## Drill Down in Power Query

Author: Branka Trifunović

For Power BI version 2.76.5678.782 (December 2019). Drill Down enables us to select a value from a table cell. Value can be saved as a new object or query and then used in further data manipulation. Instead of selecting a

## International Bussines Communication Standards

Author: Branka Trifunović

For Power BI version 2.76.5678.782 (December 2019). International Business Communication Standards or IBCS is a set of rules for unified look of business reports. Rules cover shapes and colors for all report elements like charts, tables, schemes and labels. Let’s

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

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

## Q&A in Power BI

Author: Branka Trifunović

For Power BI f version 2.76.5678.782 (December 2019). Q&A is one of the most powerful features of Power BI. It enables us to ask questions in simple Natural Query Language. We can simply browse and visualize data. We can plot

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

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

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

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

## Calendar in Power BI

Author: Branka Trifunović

In this article we’ll discuss what the calendar table looks like and how to use it in Power BI model. Calendar table is the most important part of Power BI model. Every data table usually contains dates, which means we

## Preparing Work Environment in Power BI Desktop

Author: Branka Trifunović

This article covers best practices for setting Power BI Desktop version 2.76.5678.782 (January 2020). Power BI consists of Power BI Desktop and PowerBI.com. Every Power Bi project starts in Power BI Desktop. Properly setting up our work environment is crucial. In

## Power BI – 5 Benefits

Author: Branka Trifunović

Data is the core of modern business, and Excel has traditionally been the go-to tool for all reporting needs. But Excel of today is hardly equipped to handle masses of data we collect. A new tool, Power BI, delivers a