Time intelligence
Computes numeric values for each year.
YEAR(Date[Date])
Adds all the numbers in a column.
SUM(<column>)
Returns a table that represents a subset of another table or expression.
FILTER(<table>,<filter>)
Find out date of today
NOW()
Calculate amount for donation
ROUND ( [Price], 0 ),
Evaluates an expression in a modified filter context.
CALCULATE(<expression>[, <filter1> [, <filter2> [, …]]])
Find out the date of tomorrow.
NEXTDAY(NOW())
Counts the number of rows in the specified column that contain non-blank values.
COUNTA(<column>)
Returns all rows in a table ignoring any filters that might have been applied inside the query
CALCULATE ([Sales Amount], ALLSELECTED ( Product[Category] ) )
Helping calculate fiscal year
IF(<logical_test>, <value_if_true>[, <value_if_false>])
Returns a sum calculated along the given axis of the visual matrix
SalesUpToDate = RUNNINGSUM([SalesAmount], Rows)
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 )
)
Return date of the same day in one year ago
DATEADD ( DateTime[DateKey], -1, YEAR )
FORMAT ( Sales[Price], "$#,0,,.0#M" )
$103,456.79M
Handle role-playing dimensions
CALCULATE ( [Sales Amount], USERELATIONSHIP ( Sales[Delivery Date], 'Date'[Date] ))