PowerPivot Calculations: DAX, KPI, Relationship and Hierarchy

DAX: Data Analysis Expressions

 

Calculated Columns

Calculated Columns will be in gray color

 

RegionUpperCase

 

GroupAndCountry

 

Region

 

TotalSalesAmount

SUMX(Table; Expression)

 

SalesAmount

 

SalesAmountShipDate

 

Measures

Sales Amount

 

SalesAmountSouthwest

 

SalesAmountPrevYear

 

KPI: Key Performance Indecator

 

Relationships

Right clicking on the column name

 

Active: Can be used by default

Inactive: Can be used in calculated columns through function Relationship

 

Diagram View

Continued Line: Active Relation

Dot Line: Inactive Relation

 

Create Relationship by drag & drop

 

Create Hierarchy