Unlock the advanced capabilities for reporting in Power BI, Excel Power Pivot, and SSAS Tabular.

Course Duration & Payment Details

Days: Monday & Wednesday
Timing: 07:00 to 09:30pm
Duration: 20 hours
Starting from: Monday, 04 January 2021
Last date of registration: Friday, 25 December 2020

Actual Fee: 18000/-  | Early bird discount: 9000/-
How to Pay: Online Payment
Bank: Habib Bank Limited (26 street, Badar Commercial, DHA Karachi)
Title: Irfan
Account No: 0011557900292501 | PK02HABB0011557900292501

Mastering DAX Outline

• Introduction to DAX

  • What is DAX?
  • Data type and operators
  • Syntax of DAX
  • Understanding calculated columns and measures
  • Why is a measure more efficient than a column?
  • Creating calculated columns
  • Formatting DAX code
  • Implicit and explicit measures
  • Understanding filter context
  • Understanding Aggregations filter context
  • Iteration / Row context
  • Measure referencing
  • Editing / Deleting measures
  • Logical Operations
  • Using variables to simplify formulas
  • Writing comments in formulas
  • What are Quick Measures?
  • Quick measure feature

• Relationship

  • Working with Multiple tables
  • Defining Relationship
  • Editing and handling multiple relationships

• Measures

  • Implicit and explicit measures
  • Measure referencing
  • Editing / deleting measures

• Date & Time Functions

  • CALENDAR
  • CALENDARAUTO
  • DATE
  • DATEDIFF
  • DATEVALUE
  • DAY
  • EDATE
  • EOMONTH
  • HOUR
  • MINUTE
  • SECOND
  • TIME
  • TIMEVALUE
  • MONTH
  • YEAR
  • FORMAT
  • NOW
  • TODAY
  • WEEKDAY
  • WEEKNUM

• Filter Functions

  • ALL
  • ALLEXCEPT
  • ALLSELECTED
  • CALCULATE
  • CROSSFILTER
  • EARLIER
  • FILTER
  • HASONEVALUE
  • ISFILTERED
  • RELATED
  • USERELATIONSHIP
  • VALUES

• Math & Trig Functions

  • ABS
  • CEILING
  • DIVIDE
  • ROUND
  • ROUNDUP
  • SUM
  • SUMX

• Logical Functions

  • IF
  • IFERROR
  • AND
  • OR
  • SWITCH

• Time Intelligence Expressions

  • DATESMTD
  • DATESQTD
  • DATESYTD
  • DATEADD
  • DATESBETWEEN
  • PERVIOUSDAY
  • PERVIOUSMONTH
  • PERVIOUSQUARTER
  • PERVIOUSYEAR
  • RUNNING TOTAL
  • SAMEPERIODLASTYEAR

• Statistical Function

  • AVERAGE
  • AVERAGEX
  • COUNT
  • COUNTA
  • COUNTBLANK
  • COUNTROWS
  • COUNTX
  • CROSSJOIN
  • DISTINCTCOUNT
  • MAX
  • MAXX
  • MIN
  • MINX
  • MEDIANX
  • RANKX
  • SUMARIZE
  • TOPN

• Text Functions

  • CONCATENATE
  • FORMAT
  • LEFT
  • LEN
  • LOWER
  • REPT
  • RIGHT
  • TRIM
  • UNICHAR
  • UPPER
  • VALUE
• Top N Values, Top N Filter, Top Order calculations, Top 10 Customers, Dynamic
• Date Table, More Scenarios of Using Calculated Tables, Performance Consideration