Ravindra BagaleCourses & study guides

13. DAX: Data Analysis Expressions

By Last updated:

Mitrano, aata sagalyat important module – DAX. Suruvatila thoda avghad vatel, pan ghabru naka, practice kela ki sope hote. Ya module madhe evaluation context (मूल्यमापन संदर्भ), CALCULATE, FILTER, ALL family, time intelligence, RANKX aani variables (तात्पुरते साठवलेले मूल्य) he sagla Blinkit data var baghu. Pratyek formula swatah type karun bagha.

What you will learn in this module

  • Calculated columns vs measures – a recap (details in Module 8)
  • Row context, filter context and context transition
  • DAX syntax, data types and operators
  • The most important DAX functions with Blinkit and Amazon Now examples
  • Quick-commerce KPIs: AOV, Avg Delivery Time, % Delivered Under 10 Mins, Cancellation Rate, Repeat Customer %
  • Time intelligence: YTD, last year, YoY %, running total, moving average
  • Ranking with RANKX and TOPN, and writing clean DAX with variables

Concepts in this chapter

  1. 13.1What is DAX?
  2. 13.2Calculated Columns vs Measures (Recap)
  3. 13.3Evaluation Context
  4. 13.4DAX Syntax
  5. 13.5Base Measures for the Quick-Commerce Model
  6. 13.6Aggregation Functions
  7. 13.7Logical Functions
  8. 13.8CALCULATE – The Most Important Function
  9. 13.9FILTER
  10. 13.10ALL, ALLEXCEPT, REMOVEFILTERS, ALLSELECTED
  11. 13.11RELATED and RELATEDTABLE
  12. 13.12USERELATIONSHIP
  13. 13.13VALUES, SELECTEDVALUE, HASONEVALUE
  14. 13.14Text Functions
  15. 13.15Date Functions
  16. 13.16Time Intelligence
  17. 13.17Ranking: RANKX and TOPN
  18. 13.18Variables: VAR and RETURN
  19. 13.19Other Useful Functions

The chapter recap is at the end of the last concept page.