DAX Formulas

BILL JELEN (MR. EXCEL) ONCE MENTIONED, ‘DAX IS SIMPLE BUT NOT EASY’.

THIS COURSE ABOUT HOW TO WRITE DAX FORMULAS OR DATA ANALYSIS EXPRESSIONS.

AT THE END OF THIS COURSE YOU WILL BE ABLE TO –

• UNDERSTAND WHAT IS DATA MODEL.
• WRITE SIMPLE DAX CODE FOLRMULAS.
• UNDERSTAND AGGREGATOR AND ITERATOR FUNCTIONS IN DAX.
• UNDERSTAND THE DIFFERENCE BETWEEN CALCULATED COLUMNS AND MEASURES.
• GET A GENERAL IDEA – WHEN DO YOU USE A CALCULATED COLUMNS AND WHEN TO USE A MEASURE.
• USE DAX FUNCTIONS IN YOUR DAX CODE.
• COUNT, COUNTA, COUNTROWS, COUNTBLANK.
• DISTINCT COUNT AND DISTINCT COUNT NO BLANK
• LOGICAL FUNCTIONS IN DAX: AND, IF IFERROR, NOT, TRUE, OR & SWITCH.
• INFORMATION FUNCTIOS IN DAX: ISBLANK, ISERROR. ‘NOT IS ERROR’ EXAMPLE
• MATHEMATICA FUNCTIONS.
• TEXT FUNCTIONS.
• CONVERSION FUNCTIONS.
• RELATIONAL FUNCTIONS – RELATED AND RELATEDTABLE.
• TABLE FUNCTIONS. FUNCTIONS THAT RETURN A TABLE OF VALUES AND NOT A SCALAR VALUE.
  • EVALUATE YOUR DAX CODE WITH DAX STUDIO.
  • UNDERSYAND THE MOST USEFUL FUNCTION IS DAX “CALCULATE” FUNCTION.
  • UNDERSTAND WHAT IS TIME INTELLIGENCE AND WRITE TIME INTELLIGENCE FUNCTIONS IN DAX.
  • FILTER FUNCTION.
  • INTRODUCTION TO : ‘ALL’, ‘ALLSELECTED’ AND ‘REMOVEFILTER’ FUNCTIONS.
  • VALUES AND DISTINCT FUNCTION.
  • EVALUATION CONTEXT: ROW CONTEXT AND FILTER CONTEXT.
  • CONTEXT TRANSITION.
• KNOW TABLE RELATIONSHIP FUNCTIONS:
  • USER RELATIONSHIP AND
  • CROSSFILTER