DAX String Function

DAX String Function

The list of keyword that perform the string function in DAX programming are

CONCATENATE 
EXACT 
FORMAT 
FIND 
FIXED 
LEN 
LOWER
LEFT 
MID 
REPLACE 
RIGHT 
REPT 
SEARCH 
SUBSTITUTE
TRIM 
UPPER
VALUE
DAX String Function was last modified: October 18th, 2017 by Justin Antony

DAX Aggregate and count Function

DAX Aggregate count Function

= Sum(Sales[Amt])

Four functions in count are
COUNT — Numeric Column
COUNTA — Count Any Column of any datatype
COUNTBLANK — Count empty cells
COUNTROWS — No of rows in a table

The Aggregate function ending with x calculate an expression (Second Parameter)
SUMX, AVERAGEX, COUNTX, COUNTAX, MINX, MAXX, DISTINCTCOUNT

cost:= SUMX(sales, sales[qty]* RELATED(Product[StdCost]))
— calculate Sum of sold quantity * standard cost from the product table for each row of sales (parameter 1)
Other words each parameter value 1 row the corresponding parameter 2 value will be calculated and return the aggregated result.

DAX Aggregate and count Function was last modified: October 1st, 2017 by Justin Antony

Tabular Model in SSAS

Tabular Model SSAS

Tabular models are in-memory databases in Analysis Services. The xVelocity in-memory analytics engine (VertiPaq) delivers fast access to tabular model objects and data by reporting client applications such as Microsoft Excel and Microsoft Power View.

Tabular models support data access through two modes: Cached mode and DirectQuery mode.
In cached mode, you can integrate data from multiple sources including relational databases, data feeds, and flat text files.
In DirectQuery mode, you can bypass the in-memory model, allowing client applications to query data directly at the (SQL Server relational) source.

Tabular Model in SSAS was last modified: October 1st, 2017 by Justin Antony

DAX Date Function ?

DAX Date Function
DATE, DATEVALUE,DAY,EDATE,EOMONTH,HOUR,MINUTE,MONTH,NOW,SECOND,TIME,TIMEVALUE,TODAY,WEEKDAY,WEEKNUM,YEAR,YEARFRAC

DAX Date Function ? was last modified: October 1st, 2017 by Justin Antony