Grand Total for Dates in Period

Question

The grand total is showing Blank while using Dates in period funciton. For example:

Calculate(sum(fact),datesinperiod(DateTime[DateKey],DATE(2007,08,24),-21,day)) gives me blank as a total. How can i fix to show grand total?

---

Words offer the means to meaning, and for those who will listen, the enunciation of truth - V for Vendetta.

Answer 1

hi can you check out this link, it may help you .

http://forum.kimballgroup.com/t1836-cube-calculations-to-date-behaviour