Real-time, Practical Training on DAX - applicable for Microsoft SSAS and Power BI. This course is applicable for those who are aware of SSAS and / or Power BI.
Daily Tasks | Weekly Interviews | Real-time Project |
Resume Guidance | Certification Guidance | Placement Services |
Data Analysis Expressions (DAX) DAX Syntax Specification for Power Pivot DAX Operator Reference for Power Pivot Parameter-Naming Conventions Understanding Functions for Parent-Child Hierarchies in DAX DAX Function Reference DAX Queries DAX Query Syntax Reference Parameters for DAX Queries Date and Time Functions Time Intelligence Functions CLOSINGBALANCEMONTH Function CLOSINGBALANCEQUARTER Function CLOSINGBALANCEYEAR Function DATEADD Function DATESBETWEEN Function DATESINPERIOD Function DATESMTD Function DATESQTD Function DATESYTD Function ENDOFMONTH Function ENDOFQUARTER Function ENDOFYEAR Function FIRSTDATE Function FIRSTNONBLANK Function LASTDATE Function LASTNONBLANK Function NEXTDAY Function NEXTMONTH Function NEXTQUARTER Function NEXTYEAR Function OPENINGBALANCEMONTH Function OPENINGBALANCEQUARTER Function OPENINGBALANCEYEAR Function PARALLELPERIOD Function PREVIOUSDAY Function PREVIOUSMONTH Function PREVIOUSQUARTER Function PREVIOUSYEAR Function SAMEPERIODLASTYEAR Function STARTOFMONTH Function STARTOFQUARTER Function BLANK Function CONCATENATE Function EXACT Function FIND Function FIXED Function FORMAT Function Pre-Defined Numeric Formats for the FORMAT Function Custom Numeric Formats for the FORMAT Function Pre-defined Date and Time formats for the FORMAT Function Custom Date and Time formats for the FORMAT Function LEFT Function LEN Function LOWER Function MID Function REPLACE Function |
STARTOFYEAR Function TOTALMTD Function TOTALQTD Function TOTALYTD Function DATE Function DATEVALUE Function DAY Function EDATE Function EOMONTH Function HOUR Function MINUTE Function MONTH Function NOW Function SECOND Function TIME Function TIMEVALUE Function TODAY Function WEEKDAY Function WEEKNUM Function YEAR Function YEARFRAC Function Filter Functions ALL Function ALLEXCEPT Function ALLNOBLANKROW Function ALLSELECTED Function CALCULATE Function CALCULATETABLE Function DISTINCT Function EARLIER Function EARLIEST Function FILTER Function FILTERS Function HASONEFILTER Function Math and Trig Functions ABS Function CEILING Function CURRENCY Function EXP Function FACT Function FLOOR Function INT Function ISOCEILING Function LN Function LOG Function LOG10 Function MOD Function MROUND Function PI Function POWER Function RANKX Function ROW Function STDEVS Function STDEVP Function STDEVXS Function STDEVXP Function SUMMARIZE Function TOPN Function VARS Function VARP Function VARXS Function VARXP Function Text Functions RIGHT Function SEARCH Function SUBSTITUTE Function TRIM Function UPPER Function VALUE Function Formula Compatibility in DirectQuery Mode |
HASONEVALUE Function ISCROSSFILTERED Function ISFILTERED Function KEEPFILTERS Function RELATED Function RELATEDTABLE Function USERELATIONSHIP Function VALUES Function Information Functions CONTAINS Function CUSTOMDATA Function ISBLANK Function ISERROR Function ISLOGICAL Function ISNONTEXT Function ISNUMBER Function ISTEXT Function LOOKUPVALUE Function PATH Function PATHCONTAINS Function PATHITEM Function PATHITEMREVERSE Function PATHLENGTH Function USERNAME Function Logical Functions AND Function FALSE Function IF Function 180 IFERROR Function NOT Function OR Function SWITCH Function TRUE Function QUOTIENT Function RAND Function RANDBETWEEN Function ROUND Function ROUNDDOWN Function ROUNDUP Function SIGN Function SQRT Function SUM Function SUMX Function TRUNC Function Statistical Functions ADDCOLUMNS Function AVERAGE Function AVERAGEA Function AVERAGEX Function COUNT Function COUNTA Function COUNTAX Function COUNTBLANK Function COUNTROWS Function COUNTX Function CROSSJOIN Function DISTINCTCOUNT Function GENERATE Function GENERATEALL Function MAX Function MAXA Function MAXX Function MIN Function MINA Function MINX Function RANKEQ Function REPT Function
|
* COMPLETE CONTENT TO BE UPLOADED BY SEP 10th, 2017.