Ravindra BagaleCourses & study guides

8. Adding Columns: Power Query Add Column Tab and DAX Calculated Columns

By Last updated:

Aata aapan navin columns kase banvaycha te shikuya – Power Query chya Add Column tab madhun aani DAX calculated columns madhun. Sobat, calculated column aani measure madhla farak khup detail madhe baghu, karan students ithech sagalyat jast confuse hotat.

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

Concepts in this chapter

  1. 8.1The Add Column Tab at a Glance
  2. 8.2Column From Examples
  3. 8.3Custom Column
  4. 8.4Invoke Custom Function
  5. 8.5Conditional Column
  6. 8.6Index Column
  7. 8.7Duplicate Column
  8. 8.8From Text: Format, Merge Columns, Extract, Parse
  9. 8.9From Number: Statistics, Standard, Scientific, Trigonometry, Rounding, Information
  10. 8.10From Date & Time: Date, Time, Duration
  11. 8.11DAX Calculated Columns
  12. 8.12Calculated Columns vs Measures in Depth
  13. 8.13Implicit vs Explicit Measures, Measure Tables, Display Folders and Formatting

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