# 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

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

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