PowerPivot: DAX: Filter Functions
User Rating: / 2
PoorBest 
Written by Ed Price   
Monday, 21 June 2010 23:51

The filter and value functions in Data Analysis Expressions (DAX) are some of the most complex and powerful, and differ greatly from Excel functions. The lookup functions work by using tables and relationships, like a database. The filtering functions let you manipulate data context to create dynamic calculations.

Read more about the Filter Functions in this article:

  • ALL
  • ALLEXCEPT
  • ALLNOBLANKROW
  • CALCULATE
  • CALCULATETABLE
  • DISTINCT
  • EARLIER
  • EARLIEST
  • FILTER
  • RELATED
  • RELATEDTABLE
  • VALUES

Read more...

 

  Tags: excel, dax
 

Varigence Vivid