marksolberg
New Member
- Joined
- Jan 14, 2014
- Messages
- 2
Here is my PrevYear expression.
=CALCULATE(sum('Accufund with Names'[Net]),PREVIOUSYEAR('Accufund with Names'[Date]),ALL('DateTable'[Year]))
The problem I'm having is that the total for the Maintenance & Repair-Parts accountname is not showing for the PrevYear column because there is no value in the 2013 column. The amount is included in the subtotal though. I've include the 2012 column to show what is missing. I'm sure this is an error in my understanding of how this calculation should work but any direction would be appreciated.
Mark
[/IMG]
=CALCULATE(sum('Accufund with Names'[Net]),PREVIOUSYEAR('Accufund with Names'[Date]),ALL('DateTable'[Year]))
The problem I'm having is that the total for the Maintenance & Repair-Parts accountname is not showing for the PrevYear column because there is no value in the 2013 column. The amount is included in the subtotal though. I've include the 2012 column to show what is missing. I'm sure this is an error in my understanding of how this calculation should work but any direction would be appreciated.
Mark
