Contact us

Send
inqury

Knowledge base

home banner

bi@unija.com

  • Knowledge

  • Categories

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

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

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

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

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

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

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

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

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

Vsebina za iskani kriterij ne obstaja.