13. DAX: Data Analysis Expressions
Friends, now the most important module – DAX. It may feel a bit hard at the start, but do not worry; with practice it becomes easy. In this module we look at evaluation context (the filters and row a formula sees), CALCULATE, FILTER, the ALL family, time intelligence, RANKX and variables (a value stored for a moment) on Blinkit data. Type every formula yourself.
मित्रांनो, आता सगळ्यात important module – DAX. सुरुवातीला थोडा अवघड वाटेल, पण घाबरू नका, practice केला की सोपा होतो. या module मध्ये evaluation context (formula ला दिसणारे filters आणि row), CALCULATE, FILTER, ALL family, time intelligence, RANKX आणि variables (थोड्या वेळासाठी साठवलेलं मूल्य) हे सगळं Blinkit data वर बघू. प्रत्येक formula स्वतः type करून बघा.
दोस्तों, अब सबसे important module – DAX. शुरू में थोड़ा मुश्किल लगेगा, पर घबराइए मत, practice करने से आसान हो जाता है. इस module में evaluation context (formula को दिखने वाले filters और row), CALCULATE, FILTER, ALL family, time intelligence, RANKX और variables (थोड़ी देर के लिए रखा गया मान) यह सब Blinkit data पर देखेंगे. हर formula ख़ुद type करके देखिए.
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
Live story: The Monday KPI cards
Suppose we are preparing the Blinkit Maharashtra monthly report for March. The state head wants five cards: Total Sales, Orders, AOV, % delivered under 10 minutes, and cancel rate. She also wants a Pune benchmark card while she looks at Nashik, and FY year-to-date from April. All of that is DAX. This chapter goes slowly: data first, then the formula, then the result.
All numbers in this story are fictional practice data.
Live story: सोमवारचे KPI cards
समजा आपण Blinkit Maharashtra चा March महिन्याचा monthly report तयार करतोय. State head ना पाच cards हवेत: Total Sales, Orders, AOV, 10 मिनिटांत पोचलेल्या orders चे %, आणि cancel rate. त्या Nashik बघत असताना त्यांना शेजारी Pune चा benchmark card पण हवाय, आणि April पासूनचं FY year-to-date पण. हे सगळं DAX आहे. हा chapter सावकाश जातो: आधी data, मग formula, मग result.
या story मधले सगळे आकडे काल्पनिक practice data आहेत.
Live story: सोमवार के KPI cards
मान लीजिए हम Blinkit Maharashtra की March की monthly report तैयार कर रहे हैं. State head को पाँच cards चाहिए: Total Sales, Orders, AOV, 10 मिनट में पहुँचे orders का %, और cancel rate. जब वे Nashik देख रही हों, तब उन्हें बगल में Pune का benchmark card भी चाहिए, और April से FY year-to-date भी. यह सब DAX है. यह chapter धीरे-धीरे चलता है: पहले data, फिर formula, फिर result.
इस story के सारे आँकड़े काल्पनिक practice data हैं.
Concepts in this chapter
- 13.1What is DAX?
- 13.2Calculated Columns vs Measures (Recap)
- 13.3Evaluation Context
- 13.4DAX Syntax
- 13.5Base Measures for the Quick-Commerce Model
- 13.6Aggregation Functions
- 13.7Logical Functions
- 13.8CALCULATE – The Most Important Function
- 13.9FILTER
- 13.10ALL, ALLEXCEPT, REMOVEFILTERS, ALLSELECTED
- 13.11RELATED and RELATEDTABLE
- 13.12USERELATIONSHIP
- 13.13VALUES, SELECTEDVALUE, HASONEVALUE
- 13.14Text Functions
- 13.15Date Functions
- 13.16Time Intelligence
- 13.17Ranking: RANKX and TOPN
- 13.18Variables: VAR and RETURN
- 13.19Other Useful Functions
- 13.20PREVIOUSMONTH, PREVIOUSYEAR, DATESMTD and Rolling 30 and 90 Days
- 13.21KEEPFILTERS, and How a Slicer Hits a Measure
- 13.22LOOKUPVALUE, TREATAS and CROSSFILTER
- 13.23Virtual Tables
- 13.24Weighted Averages and FILTER inside an Iterator
- 13.25IFERROR, Blank versus Zero, and Circular Dependency
- 13.26Dynamic Segmentation, Pareto and ABC
- 13.27DAX Query View
Review and practice
The chapter recap is at the end of the last concept page.
Ravi Sir's Cards: 37 revision, interview and comparison cards for this chapter · मराठी cards