8. Adding Columns: Power Query Add Column Tab and DAX Calculated Columns
Now we learn how to make new columns – from Power Query's Add Column tab and with DAX calculated columns. Along with that, we look at the difference between a calculated column and a measure in detail, because this is where students get confused the most.
आता आपण नवीन columns कसे बनवायचे ते शिकूया – Power Query च्या Add Column tab मधून आणि DAX calculated columns मधून. सोबत calculated column आणि measure मधला फरक खूप detail मध्ये बघू, कारण students इथेच सगळ्यात जास्त confuse होतात.
अब हम नए columns बनाना सीखते हैं – Power Query के Add Column tab से और DAX calculated columns से. साथ ही calculated column और measure का फ़र्क बहुत detail में देखेंगे, क्योंकि students यहीं सबसे ज़्यादा confuse होते हैं.
What you will learn in this module
- Every option on the Power Query Add Column tab, with an example on our data
- DAX calculated columns: RELATED, IF, SWITCH, date parts and bucket columns
- Calculated columns vs measures in depth: storage, context, when to use which
- Implicit vs explicit measures, measure tables, display folders and formatting
Live story: A basket-size slicer for the category team
Suppose the Blinkit category team asks: "How many orders are below ₹199?" Our data has the amount, but not a band like Below ₹199 / ₹199–498 / ₹499+. We need a new column. Power Query or DAX? Column or measure? This chapter answers that, with the Add Column tab and DAX calculated columns.
All numbers in this story are fictional practice data.
Live story: Category team साठी basket-size slicer
समजा Blinkit ची category team विचारते: "₹199 पेक्षा कमी किती orders आहेत?" आपल्या data मध्ये amount आहे, पण Below ₹199 / ₹199–498 / ₹499+ असा band नाही. आपल्याला नवीन column हवाय. Power Query की DAX? Column की measure? हा chapter Add Column tab आणि DAX calculated columns सोबत याचं उत्तर देतो.
या story मधले सगळे आकडे काल्पनिक practice data आहेत.
Live story: Category team के लिए basket-size slicer
मान लीजिए Blinkit की category team पूछती है: "₹199 से कम कितने orders हैं?" हमारे data में amount है, पर Below ₹199 / ₹199–498 / ₹499+ जैसा band नहीं है. हमें नया column चाहिए. Power Query या DAX? Column या measure? यह chapter Add Column tab और DAX calculated columns के साथ इसका जवाब देता है.
इस story के सारे आँकड़े काल्पनिक practice data हैं.
Concepts in this chapter
- 8.1The Add Column Tab at a Glance
- 8.2Column From Examples
- 8.3Custom Column
- 8.4Invoke Custom Function
- 8.5Conditional Column
- 8.6Index Column
- 8.7Duplicate Column
- 8.8From Text: Format, Merge Columns, Extract, Parse
- 8.9From Number: Statistics, Standard, Scientific, Trigonometry, Rounding, Information
- 8.10From Date & Time: Date, Time, Duration
- 8.11DAX Calculated Columns
- 8.12Calculated Columns vs Measures in Depth
- 8.13Implicit vs Explicit Measures, Measure Tables, Display Folders and Formatting
Review and practice
The chapter recap is at the end of the last concept page.
Ravi Sir's Cards: 18 revision, interview and comparison cards for this chapter · मराठी cards