Has anyone figured out how to get DAX to access cells or named ranges? The PowerPivot FAQ says "Unlike Excel formulas, DAX has no notion of addressing individual cells or ranges". I'm hoping there is a way around this.
Specifically, I'm trying to use a calculated date form cell (A5) and use...