| Touchdown Problem Solved, and COUNTROWS |
| Written by Rob Collie |
| Saturday, 09 January 2010 03:20 |
|
In the last post I was struggling with horribly-designed source tables. To be honest, I never found a way to relate those two tables to each other, even through other intermediate tables that initially seemed promising. But I DID find two columns in my Plays table itself that saved my bacon – [OffensiveTeamScoreAtPlayStart] and [OffensiveTeamScoreAtPlayEnd]. A simple calc column subtracting the two and now I have [PtsScoredOnPlay]: |
Most Popular
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- List of suggested datasets to test PowerPivot
- List of PowerPivot DAX functions with description
- How to install PowerPivot for Excel and list of know issues
- Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction
- List of PowerPivot DAX functions (short)
- Learning PowerPivot and DAX
- PowerPivot's impact on BI pros?
