Forum Discussion
Difference between 2 columns in Matrix or Table
Using an Enter Data query, I created a table with the following values:
- S14
- S15
- S16
Relate this table to your other table. I then created the following measures:
SumUnitsTaken = SUMX(RELATEDTABLE(College),'College'[Unit Taken]) S15 vs S14 = CALCULATE([SumUnitsTaken],College[Term] = "S15") - CALCULATE([SumUnitsTaken],College[Term] = "S14") S16 vs S15 = CALCULATE([SumUnitsTaken],College[Term] = "S16") - CALCULATE([SumUnitsTaken],College[Term] = "S15")
Create a table with College, S15 vs S14 and S16 vs S15
Using an Enter Data query, I created a table with the following values:
- S14
- S15
- S16
Relate this table to your other table. I then created the following measures:
SumUnitsTaken = SUMX(RELATEDTABLE(College),'College'[Unit Taken]) S15 vs S14 = CALCULATE([SumUnitsTaken],College[Term] = "S15") - CALCULATE([SumUnitsTaken],College[Term] = "S14") S16 vs S15 = CALCULATE([SumUnitsTaken],College[Term] = "S16") - CALCULATE([SumUnitsTaken],College[Term] = "S15")
Create a table with College, S15 vs S14 and S16 vs S15
Greg_Deckler For my own learning, can I ask the purpose of the Enter Data table you used? I got to the same end result of the desired matrix with just the three measures:
SumUnitsTaken = SUM(TableName[Unit Taken]) S15 vs S14 = CALCULATE([SumUnitsTaken], TableName[Term]="S15") - CALCULATE([SumUnitsTaken], TableName[Term]="S14") S16 vs S15 = CALCULATE([SumUnitsTaken], TableName[Term]="S16") - CALCULATE([SumUnitsTaken], TableName[Term]="S15")
Probably because I'm old school and still think in star schemas and snowflake schemas and fact and dimension tables. Old habits die hard.
Ha, nothing wrong with that! I just thought I might be missing out on something cool. Thanks!
