DAX QUIZ

Time intelligence

100

Computes numeric values for each year.

YEAR(Date[Date])

200

Find out date of today

NOW()

300

Find out the date of tomorrow.

NEXTDAY(NOW())

400

Helping calculate fiscal year

IF(<logical_test>, <value_if_true>[, <value_if_false>])

500

Return date of the same day in one year ago

DATEADD ( DateTime[DateKey], -1, YEAR )

Calculation

100

Adds all the numbers in a column.

SUM(<column>)

200

Calculate amount for donation

ROUND ( [Price],  0 ),

300

Counts the number of rows in the specified column that contain non-blank values.

COUNTA(<column>)

400

Returns a sum calculated along the given axis of the visual matrix

SalesUpToDate = RUNNINGSUM([SalesAmount], Rows)

500

Represent currency values in millions 

FORMAT ( Sales[Price], "$#,0,,.0#M" )

$103,456.79M  

Filters

100

Returns a table that represents a subset of another table or expression.

FILTER(<table>,<filter>)

200

Evaluates an expression in a modified filter context.

CALCULATE(<expression>[, <filter1> [, <filter2> [, …]]])

300

Returns all rows in a table ignoring any filters that might have been applied inside the query

CALCULATE ([Sales Amount], ALLSELECTED ( Product[Category] ) )

400

Returns the value for the row that meets all criteria specified by one or more search conditions.

VAR BirthDate = Customer[Birth Date]

VAR ReferenceYear = 2009

VAR WeekdayOnBirthday = LOOKUPVALUE (

    'Date'[Day of Week],

     'Date'[Calendar Year Number], ReferenceYear,

     'Date'[Month Number], MONTH ( BirthDate ),

      'Date'[Day], DAY ( BirthDate )

)

500

Handle role-playing dimensions

CALCULATE (  [Sales Amount], USERELATIONSHIP ( Sales[Delivery Date], 'Date'[Date] ))